Fact is the central control table, relating all other tables. It coordinates the other star schema tables to create and populate multidimensional databases in Essbase. The Fact table contains the exported data—each row is a single data cell, using the names stored in the outlying tables.
Table 10. The Fact Table
Attribute | Data Type | Definition |
|---|
AnalysisID | int | References the Analysis table. |
EntityID | int | References the Entity table. |
ScenarioID | int | References the Scenario table. |
AccountID | int | References the Account table. |
TimeID | int | References the Time table. |
UDDim1 | int | References the User-Defined Dimension table 1. |
UDDim2 | int | References the User-Defined Dimension table 2. |
UDDim3 | int | References the User-Defined Dimension table 3. |
UDDim4 | int | References the User-Defined Dimension table 4. |
DataValue | numeric | Stores numeric values |
DataStringValue | nvarchar | Stores string values |