I had a new measure to add to my cube a new measure. My fact table up till now was with a monthly granularity. I assumed that I would have to define a scope in MDX for the intermediate period and the monthly period. I connected the fact to the year level in the Period dimension and got this message: If you select a non – key granularity attribute, the server will not be able to aggregate data properly unless you make sure that all other attributes are directly or indirectly related to it by specifying...
Creating Sum for a Group with Recursion in SSRS Sum with scope A colleague of mine from work was creating a report with Reporting Services 2005. He had a matrix report like the following: Year Total Total Sales Per Year % of Sales from the Total Sale Per Status Status 1 Total 2 3 He wanted to calculate the percent of total for that year from the total for that row. I remembered from looking at the Sum function in SSRS that it had 3 options – with scope and recursion. So I thought – I should try the...