- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 68 Insurance
- 536.8K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Multiple Fact tables for single Measure
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 22.214.171.124.