Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 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
12c many to many relationship inside dimension hierarchy?
User_0PDV4
Rank 4 - Community Specialist
I have tried to solve this with bridge tables, with snowflakes and I don't know how many different versions, but I still can't get it work. When fact has multiple rows for the lowest dimension level values (as it always will), OBIEE multiplies the data. My data model looks like this:
How should I model that N:N between user and group AND get the right data out from my fact? This works fine as long as I don't add the group anyway. And pls do not link any documentation, blogs or such unless it describes exactly this situation - I have checked them already and they didn't help. I need now step-by-step plan to sort this out.
Tagged:
0