Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tabular - aggregate data in the fact table? Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 8:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:39 AM
Points: 364, Visits: 175
Hello

I'm currently designing a new tabular model which contains sales data. The sales data is received at a low level hierarchically speaking (Day, Store, SKU). The reports for this dataset however are not required at such a low level. The requirement is to view the data by month, county and product group.

Should I aggregate the data in the fact table to month, county and product (using a view or a SQL statement) or should I allow tabular to use the hierarchies in the warehouse to aggregate the data?

Any advice would be appreciated.

Post #1443318
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse