When we browse the cube in management studio we are able to see the correct aggregates where as in the report from reporting services we are just getting the sums instead of running aggregates especially in the intersection cells of columns and rows. ( where ever the aggregrate function is difference/division. )
Is there a setting in reporting services which would make the report return the running aggregates like in the management studio.
thanks in advance
The brower is diferent in Reporting Services, but if you use the MATRIX in reporting Services, you all the cells for columns, rows and data!
Try it... if you never did that, use the wizard!
Helped?
Regards!
|||--
|||
PedroCGD wrote:
The brower is diferent in Reporting Services, but if you use the MATRIX in reporting Services, you all the cells for columns, rows and data!
Try it... if you never did that, use the wizard!
Helped?
Regards!
Can you eloborate please.
Even when I use the matrix and the wizard still it dosent give me the running aggegates it is just giving me the sum in the intersections cells.
Any thots ?
No comments:
Post a Comment