Activating Inactive Dimensions

Not all dimensions in the EPM database are active by default. Depending on the subrecord, five to eight dimensions are delivered as inactive because, on database platform DB2/OS390, indexes have a limit of 255 characters. If PeopleSoft were to activate all dimensions, then some indexes would exceed that limit. Furthermore, the maximum number of index columns is 32 for the Oracle database platform.

This section describes how to activate inactive dimensions. If you do not intend to use these inactive dimensions, then you can leave them inactive and ignore the remainder of this section. If you are unsure whether or not you will use a dimension, consider activating it. Not using an active dimension has minimal system impact; whereas, storing data in an inactive dimension could cause data integrity errors.

For subrecord BP_CF9B_AK_SBR, the following eight dimensions are delivered as inactive:

For subrecord CF9A_PK_SBR, the following five dimensions are delivered as inactive:

To activate a dimension:

1. Launch Application Designer.

2. Select File, Open.

3. In the Open Definition dialog box, set Definition to Record and Type to Subrecord.

4. Enter subrecord BP_CF9B_AK_SBR, and then click Search.

5. To view the key field setting of the active subrecord, select View, Use Display.

   Eight of the dimensions are not marked as keys.

6. Right-click each dimension that you want to activate, and then click Record Field Properties.

7. In the Record Field Properties dialog box, select Key and Search Key, and then click OK.

   On a DB2/OS390 database platform, to keep indexes within the 255-character limit, for each dimension that you activate, be sure to deactivate any unused dimensions by clearing Key and Search Key.

   On the Oracle database the maximum number of index columns is 32.

8. Save your changes to the subrecord.

9. For subrecord CF9A_PK_SBR, repeat the earlier steps. Use this subrecord if you are modifying LEDGER_PROJ.

10. In Application Designer, select File, New to create a project.

11. Select Insert, Definitions Into Project, and then insert the following record IDs that contain either subrecord CF9A_PK_SBR or BP_CF9B_AK_SBR:

    LEDGER_PROJ	BP_LED_E00	BP_LN_PCANN_T
    BP_ALLC_AMT_T	BP_LED_F00	BP_LN_PCPRD_T
    BP_ALLC_TAM_T	BP_LED_KK_E00	BP_LN_PRDTL_T
    BP_ASSET_T	BP_LED_KK_F00	BP_LNITMRPT_T
    BP_ASST_DPR_T	BP_LED_KK_T	BP_TGT_LEDB_EX
    BP_CF_LI_ERR	BP_LED_PROJ_E00	BP_TGT_LEDB_T
    BP_DIM_DTL_AET	BP_LED_PROJ_F00	BP_TGT_LEDC_EX
    BP_DIM_DTL_TBL	BP_LED_PROJ_T	BP_TGT_LEDC_T
    	BP_LED_T	BP_TGT_LEDP_EX
    BP_LD_BDG_TT	BP_LI_FLX_INFC	BP_TGT_LEDP_T
    BP_LD_TT	BP_LINE_CF_SBR	BP_TGT_LINE
    BP_LED_BUDG_E00	BP_LINE_ITM_T	BP_TGT_LINE_ERR
    BP_LED_BUDG_F00	BP_LINE_WRK	BP_TGT_LINE_T
    BP_LED_BUDG_T	BP_LN_AMUNT_T

12. Save your changes.

13. Select Build, Project.

14. In the Build dialog box, select Create Indexes and Execute and build script.

15. Click Settings, and then select Recreate index only if modified.

16. Click OK.

17. In the Build dialog box, click Build.

    Note: For database platforms DB2/OS390 and DB2/UNIX, you must recreate all views.

Any dimensions that are delivered as non-keys do not display on the Ledger Template page (EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template). To see the newly activated dimensions on the Ledger Template page, follow these additional steps:

1. Recompile the record metadata for the Ledger Template record(s) select (EPM Foundation, then select Foundation Metadata, then select Metadata Creation and Editing, then select Record Metadata).

2. Navigate to the Ledger Template page (EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template). Ensure that all the active dimensions are displayed under the ChartFields folder. Click the Refresh Detail ChartFields icon (top right) to display all the dimensions, if necessary.

3. Click Save.