Data model issue - Merging 2 fact tables into 1

sibin_jacob — Mon, 01 Jul 2013 19:00:15 GMT

Hi All,

I have two levels of data in my application. So I am keeping two fact tables. One is at summary level and the other one is at detail level.
I can’t roll up the detail data why because I have only 13 week data at my detail level but I have 2 years of data in my summary table. I created a data
model with two fact table. I am able to achieve all the dashboard functionality. But I need to merge these two fact table to improve the performance
of the tool. I am facing some problems in my dashboard after merging the fact tables that is when I select detail data it is clearing my time period selection.

Here I am attaching my both the applications .First one with two fact table and the other one with merged fact table.

Please help me to change the loading script properly.

old data model

New data model

Thanks,

Sibin Jacob. C

topic Data model issue - Merging 2 fact tables into 1 in QlikView

Data model issue - Merging 2 fact tables into 1