Using CM Metadata User Procedure

Use the CM metadata user procedure to create new entries in the metadata tables. It helps in migrating the same metadata to different environments. This procedure is used to populate custom labels for the dashboards.

To execute the CM metadata procedure:

1. Create a CM_<PROD_FLG>_CREATE_METADATA procedure.

Replace <PROD_FLG> with the appropriate source application code. For example: CCB, NMS, MDM, or MWM.

2. Add the appropriate data population scripts.

These should be written as merge statements, so the existing rows are skipped and only new rows are added. In case the metadata requires corrections, use the update clause of the merge statement.

All tasks within the procedure should have the logical schema set to “Metadata”. The schema names should not be hard coded.

3. Create a CM_<PROD_FLG>_CREATE_METADATA package.

4. Add the procedure created in step 1 and then add the B1_CFG_METADATA scenario.

B1_CFG_METADATA pulls additional metadata from the source based on the list of tables to extend the replication.

5. After migrating the CM Project to a new environment, add the product instance.

6. Execute the CM_<PROD_FLG>_CREATE_METADATA custom procedure.

This job should be executed in the context of the product.