I try to write a calculated member that returns the percentage of total (but independent from the chosen dimensions). So i started with the included template "Percentage of total".
When i use the measure in my cube browser, it works so far, but not when i use the measure in excel client.
The problem is the root-function. When i place my dimension in the rows-section and deselect some members in the filter-window, the root-function isn't influenced by the filter in excel. When i browse the cube in SSMS it gives the correct result, because
the filter is applied to it.
You can reconstruct the problem very easily by adding this measure: "Root([Dimension Name]),[Measures].[Measure Name]"
This is a big problem in my case, because i absolutely need a grand total, that uses the filter-selections.
I already spent days to find a way, how to write e calculated measure, that just gives me the grand total according to the filter and which i can use with different dimensions. Or is there any way to access the calculated grand total cell in MDX? I can't
believe that my problem is so difficult to solve.
Please help me out!
View Complete Post