RPD - Working with CONFRMED & NON-CONFORMED dimensions in Fusion

Ramya B M-Oracle

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Oracle ACS

Description (Required):

In current scenario, we can work only with multiple Fact Tables with only CONFORMED Dimensions. However, when we want to use NON-CONFORMED Dimensions, Reports ended up showing two records/wrong data.

Use Case and Business Need (Required):

Currently, below are the Subject areas used in the OTBI Report - MTN Data Cleanliness Report L2.

- Workforce Management - Person Real Time

- Workforce Management - Worker Assignment Real Time

When we try to fetch the Nationality using the Workforce Management - Person Real Time, we are able to get the Nationality data for all the employees. But whereas when we combine both the Subject areas and try to fetch the data, for certain employees - the Nationality is blank/empty.

Enhancement Request / Service Request:

In order to work with multiple Fact Tables & Non-Conformed Dimensions, Fusion RPD has to be modified as per below Document.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=74818647365193&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=1396495.1&_afrWindowMode=0&_adf.ctrl-state=11r80vq6pf_125