topic Re: Dimension and Fact contain same fields in QlikView

Dimension and Fact contain same fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

i need your help, i have 4 dim table product,prodcategory,prodsubcategory and salesterritory and 1 fact table internetsales

from them product dimension and internetsales fact contain a same field.

while i loaded this table in script & check data model it forms:

autoconcatenate in between product and internetsale
product and salesterritory have relationship between them
productcategory and productsubcategory have relationship between them (only connected to each other not to others)

so i used concatenate in between product and productcategory table and used QUALIFY and UNQUALIFY to internatesales table

after that it create a snow flake schema model as ↓

i come to know , i am going with right way or there is another way to solve it, please let me know..

Thank you.

Re: Dimension and Fact contain same fields

Anil_Babu_Samineni — Mon, 04 Sep 2017 02:29:11 GMT

Some what we are walking good approach. Here, I don't use QUALIFY Statement unless needed..

Re: Dimension and Fact contain same fields

Anonymous — Mon, 04 Sep 2017 09:00:57 GMT

then what should i have to used beacuse it contain synthetic key

Re: Dimension and Fact contain same fields

Anil_Babu_Samineni — Mon, 04 Sep 2017 09:03:44 GMT

In your model, I haven't seen any Synthetic Key. Any way, May be create Link Table to achieve this?

Re: Dimension and Fact contain same fields

Anonymous — Mon, 04 Sep 2017 09:11:35 GMT

without using any function i load a script then it look like ↓

product(dim) and internetsales(fact) get autoconcatenate.

Re: Dimension and Fact contain same fields

Anonymous — Mon, 04 Sep 2017 09:13:28 GMT

to create link table it required more than one fact table but in my model only one fact table is there.

Re: Dimension and Fact contain same fields

Anil_Babu_Samineni — Mon, 04 Sep 2017 23:04:25 GMT

True, That is the case why are you using QUALIFY statement in your mode... I can't help now. It's late night to me. Going to sleep

Re: Dimension and Fact contain same fields

Anonymous — Mon, 04 Sep 2017 23:08:04 GMT

ok,btw thank you so much..

Re: Dimension and Fact contain same fields

qliksus — Tue, 05 Sep 2017 04:12:51 GMT

There is orderdate in both the product and internetsale table So its better to create a common calendar in your schema . So its better to combine the Product and internetsale table into one table and then use the dates field to connect to the calendar table