topic Re: Datamodel issue with 2 fact tables in QlikView

Datamodel issue with 2 fact tables

Thu, 09 Jul 2015 11:34:37 GMT

Hi Frnz,

I need small favor from you.

I would like to map FACT_RATIO_L4 ====> DIM_ACCOUNT through L4AMID

FACT_RATIO_L2 ====> DIM_ACCOUNT through L2AMID

FACT_RATIO_L4 ====> DIM_PRODUCT through PRODUCT

FACT_RATIO_L2 ====> DIM_PRODUCT through PRODUCT

I tried concatnate two fact tables, but i am not getting exact values.

Please help me to find a best solution.

Please find the attached QVW.

avinashelite — Thu, 09 Jul 2015 11:40:33 GMT

I didn't your exact requirement...can you please elaborate bit more

Thu, 09 Jul 2015 11:45:04 GMT

Hi Avinash,

In Qvw, If I uncomment PRODUCT in FACT_RATIO_L2. I am Getting Circular Ref. I would like to merge 2 fact tables and links to as i mentioned above.

And 2 Fact tables have different data.

avinashelite — Thu, 09 Jul 2015 11:52:13 GMT

check this attachment :

hope this helps you

svenkita — Thu, 09 Jul 2015 11:57:33 GMT

the data in the qvw does not give much... it would be good if you could elaborate more on the requirements.

with your current data-model if you just change

FACT_RATIO_L2: statement to Concatenate(FACT_RATIO_L4) it should be concatenating both the facts, but this will give you a synthetic keys...

Thu, 09 Jul 2015 12:37:24 GMT

Hi,

It is working. But in DIM_ACCOUNT, it is not taking remaining fields. I have 6 fileds in DIM_ACCOUNT.It is showing only " key". How can i get?

avinashelite — Thu, 09 Jul 2015 12:43:04 GMT

can you share your script ??

Thu, 09 Jul 2015 12:51:41 GMT

Hi Avinash,

Plz find attachment.