Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 217 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Semantic Modeler consistency checker should warn missing primary keys for logical dim tables
Pratap Kondamari-Oracle
Rank 2 - Community Beginner
When logical dimension tables, especially having hierarchies does not have a logical primary key defined, visualizations throws the error: … drilldown levels associated with multiple (likely overlapping) dimensions. And it is really not easy to diagnose the column causing the issue, even if you figure out the column, not easy to guess the solution.
It took enormous effort for me to figure out the reason was not having primary key.
As per this article, it is mandatory to have primary key for logical dimension tables, request dev team to have this validation in consistency checker.
Tagged:
2