SSRS aggregate function
I have an SSAS MDX query that uses a calculated member; when adding the subtotal in the report I would like to rely on SSAS doing to aggregation rather than the incorrect sum SSRS is trying to do. But when I use =Aggregate(Fields!x.Value) I dont get anything back, the cell is blank. Why? Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx
November 15th, 2010 3:32pm

If you are trying to use a calculated member to perform the aggregate, why then do you need =Aggregate(Fields!x.Value) ? Unless I'm mistaken that you're performing the aggregation inside the calculated member?
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 11:12pm

Yes, you are correct. Sorry I forgot to mention that what I need is the TOTAL aggregate (for the (all) member). SSRS doesnt fall back and uses the (all) member for the total/subtotal rows, instead it does a straight (SUM, MIN, MAX...) which is incorrect. So we end up having to recreate the calculation all over again as an SSRS expression which is not optimal as we have the same calculation in two places (SSAS as well as SSRS) So I thought using the SSRS Aggregate will force the tablix cell to fall back and use the data source aggregation instead of trying to compute it itself Any ideas in how to get around this? Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx
November 16th, 2010 8:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics