A column which shows measure values of three different bex dp's/query/reportnamess
I have three bex query's. After i merge my three serial numbers dimensions i will have a new object. we can expand it and see the three objects.
New Merged Serial Number
+ Serial from Q1
+ Serial from Q2
+ Serial from Q3
Drop the New Merged Serial Number into a table.
Now is what my problem is, Then drop any measure from Q1 into column next to the Dropped New Merged Serial Number in the table.
What iam in need i:
get value of other measures Q2, Q3 in same column where Q1 is dropped based on its data provider/query name in WEBI.
So my end result will be having one column which shows measures of three different bex dp's/query/reportnames associated to its New Merged Serial Number into a table.
Appreciate your help.