Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 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
Drill through analysis from two fact tables
mmajdana1
Rank 6 - Analytics & AI Lead
Hi , I am using OBIEE 12.2.1.2.0
On my master analysis i have year as a column on my pivot table, this year is not from my date dimension it is from fact table beacuse it is one of the attributes which is not related to period ,
On my drill analysis I pass the parametrs with action links, and it is all ok because i have common dimensions between two fact tables.
However i dont have a conection between year from aggregat fact table and year from detailed fact table, but i have to pass that value.
How can i achieve this?
0