Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Multiple Fact tables for single Measure

Received Response
11
Views
1
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited Aug 13, 2024 5:07PM in Oracle Analytics Forum

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,

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    In the RPD you make a single logical fact table, having 2 logical table sources pointing to Fact_1 and Fact_2 and you define the fragmentation rules to tells OBIEE what LTS does contains what data. The tool will do the job by queries one, the other or both depending on the fragmentation rules you set and the analysis you build.