Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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 3 - Community Apprentice
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