Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 193 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
RPD - Working with CONFRMED & NON-CONFORMED dimensions in Fusion
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.