Drill through analysis from two fact tables — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Drill through analysis from two fact tables

Question
1
Views
0
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead
edited Aug 13, 2024 7:11PM in Oracle Analytics Cloud and Server

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?