E.1 Database Tables used for Dimensions
The following table lists the database tables used for dimensions.
Table E-1 Database Tables Used for Dimensions
| Dimension | Table Names | Filter Criteria |
|---|---|---|
| Forecast Set |
FSI_M_BSP_FCAST_SET FSI_M_OBJECT_DEFINITION_B FSI_M_OBJECT_DEFINITION_TL |
Based on Forecast set id |
| Scenario |
FSI_CONSOLIDATION_CD FSI_CONSOLIDATION_MLS |
|
| Version |
FSI_VERSION_CD FSI_VERSION_MLS |
|
| Legal Entity |
DIM_LEGAL_ENTITY_B DIM_LEGAL_ENTITY_TL |
|
| Leg Type |
FSI_LEG_TYPE_CD FSI_LEG_TYPE_MLS |
|
| Result Type |
FSI_RESULT_TYPE_CD FSI_RESULT_TYPE_MLS |
|
| Financial Element |
DIM_FINANCIAL_ELEMENTS_B DIM_FINANCIAL_ELEMENTS_TL |
Financial element ids less than or equal to 650 will be exported |
| Currency |
FSI_CURRENCY_MLS FSI_CURRENCIES |
All the active currencies will be exported |
| Planning Center |
DIM_ORG_UNIT_B DIM_ORG_UNIT_TL |
Based on the application preferences planning center dimension table is selected |
| Planning Product |
DIM_GENERAL_LEDGER_B DIM_GENERAL_LEDGER_TL Or DIM_COMMON_COA_B DIM_COMMON_COA_TL or DIM_PRODUCTS_B DIM_PRODUCTS_TL |
Based on the application preferences product dimension table is selected |
| Forecast Set Master Results | FSI_O_BSP_MASTER_RES_DTL | Based on Forecast set id |