Our Budget/Plan has Quarter grane, while Fact sales data is stored Dayly. To build Plan-Fact reports for Monthes, Weeks and Dates - I need to split Budget evenly between Calendar dates. How can I do this within a Cube?
After hours of googling I've found references to [IgnoreUnrelatedDimensions] property of Measure Groups only. But it's purpose is different - it stops populating (copying) of measure's values from the most close hierarchy level down to it's children beneath grane border. I do not need to populate values, I need to split them evenly between all children
Here is a workaround for SSAS calendar granularity depth, which I was offered on behalf of two SSAS architects, who used to know what they are talking about: I should prepare all necessary grained data in the data warehouse and load it to the SSAS Cube ready-to-use without additional tricks there in mdx model. I did it this very way and now my reports are fine.
Nevertheless, it would be interesting to look at native SSAS decision for calendar grannularity drilling too. If anybody knows it - post it here, please!