Datamodel issue with 2 fact tables

[#1]

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]

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

[#3]

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]

check this attachment :

hope this helps you

[svenkita]

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...

[#6]

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]

can you share your script ??

[#8]

Hi Avinash,

Plz find attachment.