8.2.1 Map New Dimensions

For user-defined dimensions, a manual update to the DIM_<DIMENSION>_V is required. To update manually, follow these steps:

1. Backup the current DIM_<CUSTOM_DIM>_V.
2. Update the following line of the view:

   INNER JOIN DIM_<CUSTOM_DIM>_TL D ON D.<CUSTOM_DIM_ID>=A.<CUSTOM_DIM_ID> AND
   A.<CUSTOM_DIM_ID> not in (-1,0)

   With the following:

   INNER JOIN DIM_<CUSTOM_DIM>_TL D ON D.<CUSTOM_DIM_ID>=A.<CUSTOM_DIM_ID> AND
   A.<CUSTOM_DIM_ID> not in (-1,0)and D.LANGUAGE = A.DEFINITION_LANGUAGE

   The change required is to add the additional language condition**** AND D.LANGUAGE = A.DEFINITION_LANGUAGE ****. "

The Custom Dimensions can be added to the target table, FCT_LEDGER_STAT by updating the configuration table FSI_BI_SETUP_TABLE. DIM_LOB and Dim_Org_Structure can be loaded manually or by using the AMHM tables and batch.

Note:

All nodes in the FCT_LEDGER_STAT table must be part of the respective hierarchies for which the SCDs run.