Adding Custom Dimensions to the Reporting Cube

Many Workforce and Strategic Workforce Planning dimensions are added to the Reporting cube (OEP_REP) by default. You can choose whether to add the custom dimensions to the reporting cube.

For new applications, you can perform this task only once, when you first enable features.

For new applications, you can also choose whether to disable Employee Demographics dimensions (Highest Education Degree, Skillset, Gender, and Age Band) from going to the reporting cube. (This option is not available for existing applications.)

For existing applications, you have a one-time option to perform this task the next time you make a change in Enable Features in either Workforce or Strategic Workforce. Before you enable features, you must clear data in the OEP_REP cube.

You can add custom dimensions using Enable Features for either Workforce or Strategic Workforce. Because the cubes are shared between the two modules, you can make the dimension updates in either module; the updates apply to both. Once you've made the change in one of the modules, you can't undo the change for the other module.

To choose whether a dimension should go in the reporting cube:

1. In Enable Features for either Workforce or Strategic Workforce Planning , in the Map/Rename Dimensions section, click next to a dimension name.
2. In the Valid For section, click Workforce Reporting Cube and then click OK.

   The label in the Selected Features column is updated to WorkforceReportingCube.

3. For new applications, to disable Employee Demographics dimensions from going into the reporting cube, click next to an employee demographics dimension name, and in the Valid For section, clear the selection for Workforce Reporting Cube and then click OK.

   The label in the Selected Features column is updated to remove WorkforceReportingCube.

Additionally, when you push data to the reporting cube, merit data is also pushed and mapped to Merit Increase in the reporting cube.