Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2012 Forums  Analysis Server and Reporting Services (2012)  Calculated measures in SSAS cube development

Author  Topic  old_cool Starting Member 1 Post Posted - 2014-11-02 : 09:36:15 Hi, I encountered an issue with calculated measures in SSAS cube development. 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 all divisions within each region. 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!