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:
- In Workforce Enable Features, in the Map/Rename Dimensions section, click next to a dimension name.
- In Enable Features for either Workforce or Oracle Strategic Workforce Planning Cloud , in the Map/Rename Dimensions section, click next to a dimension name.
- In the Valid For section, click Workforce
Reporting Cube and then click OK.
The label in the Selected Features column is updated to WorkforceReportingCube.
- 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
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.