Designing cubes and fact tables for drill-through

Designing cubes and fact tables for drill-through

Post by P Taylo » Fri, 10 Aug 2001 22:22:53



Is it possible ( and if so, how) to have a fact table that has transactional
detail and build a cube from it which is summarized at, say, a daily level?

TIA

 
 
 

Designing cubes and fact tables for drill-through

Post by George Spoffor » Sat, 11 Aug 2001 10:49:36


Build it as you would any other star schema. The measure aggregation functions
(SUM, MAX, etc.) will be applied to each record as it enters the leaf-level
cells as well as up to higher-level cells. Your time dimension would only go
down to day level in your scenario.


> Is it possible ( and if so, how) to have a fact table that has transactional
> detail and build a cube from it which is summarized at, say, a daily level?

> TIA

--
George Spofford
Microsoft MVP
Chief Architect and Microsoft OLAP Solution Provider/Mentor
DSS Lab