Charles Hearn (8/29/2012)
allmhuran (8/29/2012)
I think you need to have your granularity at a lower level, such as rental transaction and add a proper date dimension. Once you have your facts at the lower grain then they should roll-up nicely within your hierarchies.
It wouldn't matter in this case.
The problem is that the product cost is less granular than the revenue. So making revenue even more granular won't help.
Tangentially, the granularity of product, period, branch was selected for the data because it meets all of the usage requirements and results in much smaller storage size and faster loading times. For the record, I've built this entire thing, from source queries, data warehouse, data cleansing, dimension and fact loads, relationships, a powerpivot file, hierarchies, and a published tabular cube all since last thursday because we needed some figures quickly... I am le tired... :doze: