Skip to Content
0

Merged dimensions and N-N relation

Oct 17, 2017 at 04:05 PM

32

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Show 1 Share
10 |10000 characters needed characters left 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

0