cancel
Showing results for 
Search instead for 
Did you mean: 

Merging an object more than once possible ?

former_member672670
Participant
0 Kudos

Hie Guys,

CAn you merge an object more than once in the same report?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What exactly you want to achieve by merging multiple times?

You can merge a dimension from more than queries without any issue..

former_member672670
Participant
0 Kudos

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?

Former Member
0 Kudos

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..

former_member672670
Participant
0 Kudos

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.

Former Member
0 Kudos

Hi Jeevan,

Just as a work around, can you create two seperate object on Sponsor Name in universe1 based on only one column from table and then try to merge universe2.Sponsor Name1 with universe1.Sponsor Name and universe2.Sponsor Name2. with Universe1.Employee ID.

I am not sure if it works

Answers (0)