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.” For instance, 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” (all aggregations), and so on.