November 2, 2014 at 7:25 am
Hi,
I encountered an issue with calculated measures in SSAS cube development. Thank you in advance for your help!
For example, the region dimension has the hierarchy:
Region 1: Northeast -> Division 1 and Division 2
Region 2: Midwest (Division 3 and Division 4)
Region 3: South (Division 5, Division 6, Division 7)
Region 4: West (Division 8 and Division 9)
But the fact table only has data for each individual division not region. Therefore, if I need to calculate the sales total for region level, I may need to use calculated measure member by aggregating on divisions within each regio.
I wrote MDX to create the calculated measure. When I query the cube by using region as the only slicer (filter), the result for all regions can be displayed properly. But if I add additional slicer (e.g. year), the data is only displayed for some specific year (e.g. 2010 only) for all regions instead of all years (2011-2013). I cannot figure out what's going wrong and how to fix it.
Thanks again for your help!
November 3, 2014 at 10:02 am
It would help if you added your query
November 5, 2014 at 11:45 am
When I browse the dimension in SSAS, I see the members are listed as
. Total_Revenue
.f Total_Revenue_Minus_Cost
It seems to me that the second one is a calculated member (tiny globe with letter f) but the first one (tiny globe without letter f) is not. How can I check the details (how it is defined, formulated, etc.) of the calculated member? Thanks in advance for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply