MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements


 

FACT Table

This table contains all the facts. Conceptually, this table is the result of applying a CUBE operator to the table that contains the atomic detail records. It has one column for each level in each dimension of the cube. The VALUE column has the actual data value.

By definition, there are n+1 columns in this table, where n is the number of rows in the LEVELS table. The names of n columns are taken from the LEVEL_NAME column of the LEVELS table. The additional column is called VALUE.

This table contains not only the atomic facts but also the aggregations of related data. For example, there is a row for "Sales for 3rd day of September 1996", which is an atomic fact. There are also rows for "Sales for September 1996", "Sales for Quarter3, 1996", "Sales for 1996", and so on, which are all aggregations.