Adding Custom Dimensions to the Reporting Cube

Many Workforce 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. Before you enable features, you must clear data in the OEP_REP cube.

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

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

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

  4. For new applications, to disable Employee Demographics dimensions from going into the reporting cube, click Rename Target Dimension/Edit icon 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.