Fact table method for this scenario

[dmohanty]

Hi All,

I need to build a fact table for below scenario. Please guide me.

• In QV GUI, need to show two tabs (below image) :
  • 1st tab holds One Month Data (Current Month - 1) : Aggregated at Month Level
  • 2nd tab holds 12 Months data  : Detailed at Date level

• For 1st tab: I am able to fetch the Data for first tab from the QVD using script calculation and store as one month QVD (aggregated at Month Level).
• For 2nd tab: 12 QVDs ( for 12 months) are stored and concatenated into one QVD. I am able to do this. (The reason for storing it as 12 QVDs, just to store the snapshot/locked records, there would be no change to records).
• 
  

Now the target to merge the 2 QVDs (structure of both QVDs are same) into one Fact table. What would be the correct approach for this, so that in report I can easily show the distinguished data?

Regards!

[maxgro]

concatenate the 2 tables adding a field to distinguish them

then use set analysis to filter the different tables depending on tab

maybe this can help you (also look for generic key in community)

Fact Table with Mixed Granularity