fact ta
1 Topic
Pulling data in from multiple fact tables for Top 20 customers
Hi, I am trying to retrieve a list of Top 20 customers based on the actual sales, and then capture the figures from three different fact tables for these 20 customers (these are three separate cubes from SAP BW). The output I am looking for is shown below: Please, note that in the data model there are no direct relationships between the fact tables. Any tip/suggestion would be much appreciated. Thank you. Fact Table 1 Fact Table 1 Fact Table 1 Fact Table 2 Fact Table 3 Customer Sales 2019 Sales 2020 Sales 2021 Bonuses 2021 Forecast 2023 A 500 500 500 200 700 B 400 400 400 200 600 C 300 300 300 200 800 Etc. 200 200 200 200 600Solved887Views0likes3Comments