- A calculated member defined in an mdx query of an SSRS report (using the aggregate function).
- A calculated member defined in the MDX Script of the cube
The calculated member of the cube calculates a ratio. What we should achieve is the ratio of the aggregated members (defined in the report) and not the aggregation of the ratios. I thought that it would be automatically enforced by:
http://msdn.microsoft.com/en-us/library/ms145539.aspx :"The exception to this precedence is the Aggregate function. Calculated members with the Aggregate function have a lower solve
order than any intersecting calculated measure."
I tried to play with the solve_order of the two calculated members (defining explicitly a lower solve_order for the aggregation defined in the report), but the calculation of the cubes is always executed first => I end up with the aggregation of
Are calculations defined in the MDX script always executed first? This doesn't seem logical to me..
Thanks a lot for your help.
View Complete Post