allmhuran (8/29/2012)
...Now assume we want to have our sales (rentals) fact table showing invoice revenue at the granularity of product, branch, and financial period.
...
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.