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

Multiple Fact tables for single Measure

Received Response
1
Views
1
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited August 2024 in Oracle Analytics Cloud and Server

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.