Forum Stats

  • 3,854,952 Users
  • 2,264,439 Discussions


Multiple Fact tables for single Measure

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




  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,688 Blue Diamond
    edited Jun 20, 2022 7:25AM


    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.

    Christian Berg-0racle