Tag Archive for: Grain

Editor’s Note:  This blog was originally posted on February 1, 2010, and has been reviewed/updated on October 5, 2020.  Quite some changes have been applied to Framework Manager tool over the past decade, we find that the tuning of determinants is still a valid approach to address issues of sharing dimensions among multi-facts, especially when two fact tables join the dimension tables at different level. For instance, sales goal vs actual sales, with sales goals typically are set at month/quarter level while actual sales are at day level.   If it is just one or two measures involved in entire model, you may consider to create alias of dimension tables to join different fact tables at each level or construct custom summary in report itself.   Have you implemented in other creative way? We would love to hear your feedback. Read more