Can you give an example of the best way to sum a row from a cube view? For example, if I add two rows to a cube view, one with a selection of members, how do I make the second row a custom sum of the first? I know one way to do it, but I don’t love it, I would love to see what else you guys recommend.

Answer

• No “elegant” ways to address this currently – options are:
  
  • Avoid using member filters (i.e., break the source rows down to more detail)
  • Replicate the member filter in a GetDataCell function on the total row
  • Create a CV Helper function to return the same thing
  • Enhancement Status: There have been numerous enhancement requests to allow CV Row/Column math to work against member expansions, as well as suppressed rows/columns. These have all been approved by Development and should be in one of the upcoming quarterly releases in 2020.

 

Source: Office Hours 2020-03-26 Partner Enablement