topic Re: Data model in QlikView

Data model

Tue, 14 Apr 2015 11:23:11 GMT

Hi ,

I am new to qlikview . This probabaly is a basic design question.

I hvae 4 fact table related to each other by commmon dimension but at different granular levels.

Hence i have Qlikview relating all the tables which is relsuting in Cartesian products and hence amplified data.

What I need is a way to unlink the 4 fact table without having to rename the common dimesnsion.As in the dashboard i need to put these common dimention ( say date) as an input for the user , which should return data/metric from all the 4 fact tables at once.

Please any suggestions!!

Regards Tanvee

Re: Data model

its_anandrjs — Tue, 14 Apr 2015 15:15:23 GMT

Hi,

Better you can concatenate all this fact table into single table and maintain the fact table flag table also for the references.

Regards

Anand

Re: Data model

Tue, 14 Apr 2015 15:24:36 GMT

Hi Anand ,

Thanks for your reply.

But is there any other way apart from merging 4 fact tables into one as then this model will be very specific to this dashboard and any future addition to this table will be diificult.

Appreciate the help!!

Regards,

Tanvee

Re: Data model

maxgro — Tue, 14 Apr 2015 21:18:52 GMT

for mixed granularity in fact tables

Fact Table with Mixed Granularity

concatenate is (usually) the easier way to manage more fact tables