on 11-27-2013 4:23 PM
Hie Guys,
CAn you merge an object more than once in the same report?
What exactly you want to achieve by merging multiple times?
You can merge a dimension from more than queries without any issue..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In my case, I am creating a combined report from 2 Universes. The combined "Employee Name" column in the Webi Report is displaying correct values for "Universe 1". However, the values for "Universe 2" are Alpha-Numeric. This is because these values are "Employee ID" from Universe 1. Thus, I need to merge "Employee ID" from Universe 1 with "Employee Name" from Universe 2 to get the correct values in the combined report. Now, the combined report also has a "Sponsor Name" column and these values are being displayed correctly for "Universe 1". But, for Universe 2, they are again displayed Alpha-Numeric because they are "Employee ID" from Universe 1. This means that I also need to merge "Employee ID" from Universe 1 with "Sponsor Name" from Universe 2. Now, how can I merge "Employee ID" from Universe 1 with both "Employee Name" & "Sponsor Name" from Universe 2? FYI, I have already merged "Sponsor Name" object from both Universes. Also, all 3 objects are defined as strings. But, "Employee Name", it is defined as a variable in Universe 1 (based on the "Employee Type" object). I have merged "Employee Type" from Universe I with "Employee Name" in Universe 2 (Universe 2 did not have "Employee Type" object; it has a derived table containing all the required columns in the combined report). Can i merge "Employee ID" with the "Sponsor Name" & "Employee Name" in 2 separate queries to get the correct result? Is this how it works?
Jeevan,
First of all to merge two objects your data type and values has to match .. you can not just have a different data type (however the char type can merged to char only) otherwise you will have to convert it in universe before merging...
Also if you have only two queries then you will only need to merge with the other query only once if you need additional restriction then I will suggest to create restriction on the report layer and show it in report based on a variable based on condition..
If your report has three queries then you can merge on the same object 2 times of the other two query objects..
My data types are the same. I have 3 queries in my report right now. Query 1 - Universe 1; Query 2 - Universe 2; Query 3 - "Employee ID" & "Employee Name" from Universe 1. I have created Query 3 to merge "Employee ID" from Universe 1 with "Employee Name" from Universe 2 to get the resulting "Employee Name" for Universe 2 because "Employee Name" from Universe 2 is linked to "Employee ID" from Universe 1. I also created a detain variable for the combined "Employee Name" Column to get the values. Now, the combined report also has "Sponsor Name" column/object which is present in both Universes. I have merged "Sponsor Name" from both Universes. The problem is that - "Sponsor Name" in Universe 2 is again linked with "Employee ID" from Universe 1. Webi 4.0 is not letting me merge "Employee ID" from Universe 1 again. How can I resolve this prob to get required combined values for "Sponsor Name" from both Universes. Thanks.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.