Fact tables

These are the fact tables that you can import data into:

Fact table	Description
FinLoc_Base	This table stores data reported before it is translated and consolidated. There is one data column for each member of the period dimension.
FinPer_Base	This table stores period translated data. There is one data column for each member of the Period dimension.
FinYTD_Base	This table stores year-to-date translated data. There is one data column for each member of the Period dimension.
XChange	This table stores the exchange rate data. There is one data column for each member of the Period dimension.
ICRepPer_Base	This table stores the periodic intercompany transaction data before it is translated. There is one data column for each member of the Period dimension.
Own_Holdings_Base Own_EffectiveOwnershipPct_Base Own_EffectiveControlPct_Base Own_Override_Base Own_ConsolidationPct_Base	These tables store ownership data. There is one data column for each member of the Period dimension however, those columns may go in different tables.

The other fact tables are populated by the Consolidate, Local Consolidation, Copy Financial Data, and the Intercompany Elimination commands. The Own_UnitType_Base table is populated (and updated) by the application based on the ownership data that is loaded.

The tables that describe the relational database dimensions and dimension members are loaded using the Import Wizard.

See Dimension properties and attributes for more information about populating dimensions with structure information.