Skip to Content
avatar image
Former Member

Merged dimensions and N-N relation

I have 2 queries and i have merged this query. below are sample data.

1) If the number is on both Q1 and Q2 matches then "A" (eg. 111)

2) If the only number is in Q2 then "B" (232)

3)If the only number is in Q1 then "C" (121)

Q1&Q2 (Merged - Result Expected) Q1 Q2

111 111 111

122 122 122

121 121 232

232

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 17, 2017 at 05:23 PM

    Hi Sudarshan,

    Please check the below link. It will give you a good idea on how merge as well as Extended Merge dimension works.

    https://blogs.sap.com/2013/12/04/merge-dimensions-and-extended-merge-in-webi/

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anish,

      Thanks I am able to merge now. but how to write a formula saying

      IF Id both matches in Cust Id and Emp Id then "A" Eg (100,200)

      IF Id Only in Cust Id Then "B" Eg(300 to 600)

      If Id only in Emp Id Then "C" (700-900)

      I need all this in one formula statement