7 Replies Latest reply: Jul 9, 2015 8:51 AM by tulasiram b RSS

    Datamodel issue with 2 fact tables

      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.