I am new to SSAS. Apologies if my question is pretty simple and answered in some other thread (though i searched and could not find solution to this).
In my application, SSAS Cubes are accessed through Excel for generating few reports.In the cube there are calculated members defined on measures which has the aggregate defined as 'SUM'.
We are getting data of these calculated members if the MDX formed while generating excel report, doesnot use Aggregates. But not getting data if the MDX uses aggregates (i.e., when multiple dimension values are selected).below are the queries for both cases:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.