Aggregate Table

building semantic layer
1

Hi gurus,

I have a Model which has 7 Fact tables,20 Dimensions and 15 Aggregate Table.
To put in simpler words i have a main fact for complaint (which is a factless fact), and dimension- product,for which i have a aggregate table which calculates the sum,count etc for the product… So,the Aggregate table has Product,count,sum etc…
similarly i have different aggregate tables for different grain. Could you please let me know the best way to use these aggregate tables and create universe on top of this Model.

Thanks in Advance.

radhan (BOB member since 2011-05-24)

2

Setup measures using the fact_complaint table and then build up your aggregate awareness from there as your grain increases.

dfoster99 :uk: (BOB member since 2010-11-05)