Hi All
I have:
- 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
the ratios.
Are calculations defined in the MDX script always executed first? This doesn't seem logical to me..
Thanks a lot for your help.
Regards
Stefan

**View Complete Post**

## SSAS Calculated Member not working as expected in a SSRS report

Dear forum guys, I have a simple cube to analyze my customer's sales. I have a Time Dimension, a Product Dimension (with a few hierarchys) and a couple measures (sales and purchase amounts).

ÃÂ

I also have defined a few Calculated Members, in particular the average sales and purchase amount over the last 12 months from the selected month.

ÃÂ

I need to show the results in a SSRS Report: the user must select a month and the report needs to show the sales and purchase amount of the selected month and the average of the previous 12 months (both for sales and purchases).

ÃÂ

Everything works perfectly if I test the cube using the Cube Browser or Excel 2007 as a client.

ÃÂ

When I define the SSRS Report I cannot get to work with the calculated members (the average): I get strange numbers which are much higher than the real numbers.

ÃÂ

I've tried both Matrix and Table reports.

ÃÂ

Can anyone suggest me what I'm doing wrong: I think this should be a very common mistake.

ÃÂ

Best regards

ÃÂ

Alessandro