Prefix Tables

For each schema format, the system creates a PREFIX_FACT table that contains keys to the dimension tables and one data field. The system also creates PREFIX_DIMENSION tables, and the HFM_EA_EXTRACT table to track extract timestamps for metadata. The system creates two tables for the Entity dimension: PREFIX_ENTITY and PREFIX_PARENT.

For the SQL and Essbase Aggregation Schema format, the system also creates PREFIX_DIMENSION_BASE tables.

For the Warehouse Normalized Hierarchy Schema format, the system creates PREFIX_DIMENSION_PARENT tables.

Note:

Base and Parent tables are not created for the View, Year, and Parent dimensions.

For example, if the Relational Table Prefix is DEMO, the system creates these tables for the Essbase format:

• HFM_EA_EXTRACT1

• DEMO_FACT

• DEMO_YEAR

• DEMO_VIEW

• DEMO_PARENT

• DEMO_SCENARIO and DEMO_SCENARIO_BASE

• DEMO_PERIOD and DEMO_PERIOD_BASE

• DEMO_VALUE and DEMO_VALUE_BASE

• DEMO_ENTITY and DEMO_ENTITY_BASE

• DEMO_ICP and DEMO_ICP_BASE

• DEMO_ACCOUNT and DEMO_ACCOUNT_BASE

• DEMO_CUSTOM and DEMO_CUSTOM_BASE