OSAdmin
Valued Contributor
 

Example:

  • Row Definition = A#Sales.Children – this produces 3 children rows
  • Nested Row Member = U1#Product.Children – this produces 5 product rows for each of the 3 Account rows
  • Desired is if for the 3rd account row, 3 products are removed from display, that only that Account row is impacted and not the other two

Answer

  • This is currently not possible in the Excel add-in…moving the UD members from one account in the example above, will result in the UD members being removed from all account upon refresh.
  • Workarounds (not ideal):
    • Specify specific member combinations/filters
    • Convert QuickView to XFGetCells, then modify
    • Enhancement Status: This has been requested (TFS#10259) and approved by Development…targeted release unknown.

 

Source: Office Hours 2020-03-26 Partner Enablement

Version history
Last update:
‎09-14-2023 08:37 AM
Updated by:
Contributors