Eric M Russell (12/15/2015)
Kimball recommends that facts of different grain, like event level facts rolled up to month level, should be contained in a separate fact table. But it seems this month rollup can be accomplished using a simple aggregate sql query with GROUP BY clause or drilling up in an OLAP viewer.
Agree
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]