Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple Fact tables for single Measure

User_JZKI6Jun 20 2022

Hi Everyone,
We are having 2 fact tables (Fact_1, fact_2), Fact_1 is having current year sales data and Fact_2 is having historical sales data other than current year and 2 Dim tables was joined for both fact tables.
In the report level if we want current sales data it has to pick from Fact_1 and if we want history sales data it has to pick from Fact_2 table how we can achieve this.
Version we are using OBIEE 12.2.1.4.
Regards,

Added on Jun 20 2022

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #obiee11g

1 comment

133 views