sql server data warehouse: What are fact tables? Y is it neccessary for Cubes....

Remember the Rubic's Cube puzzle toy? Picture that as your OLAP cube. Each
colored square represents a cell. One row in your fact table becomes a cell
in your cube for a given measure.

It is the lowest level of detail and thus gives the ability to roll-up
values (aggregate) at various dimensional levels.

--
RDA Corp
Business Intelligence Evangelist Leader
www.rdacorp.com


[quoted text, click to view]