Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Tabular - aggregate data in the fact table? Expand / Collapse
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: Tuesday, May 27, 2014 9:38 AM
Points: 380, Visits: 176

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