Skip to Content
0
Former Member
Feb 24, 2009 at 11:25 PM

How to merge details from 2 different universe through webi (XIR2)u2026.

1295 Views

I have 2 DPs with one common dimension and 2 uncommon dimensions each...

DP1

EmployeeID

Name

Address

DP2

EmployeeID

Title

BirthDate

I bring both queries in. I merge on EmployeeID. To get the Name, Address, Title and BirthDate to all appear in the same block, I understand that I would have to make either Name/Address or Title/Birthdate to be details of there respective EmployeeID. My question is, what if I make these four columns details from within their respective universe (and not from the report). I can't get these columns to appear in the same block. Keeps getting incompatible object. What's the difference between making details on the report side (as oppose to from the universe)? I want to make it easy for report developers and not to always make uncommon demensions to be details from the report side.

In each of the universe, when I create the details, I specify which dimensions they are associated with. From within the Webi report, once I merge the common dimension (EmployeeID), I would see the Imcompatible Object message only if I try to DRAG the detail objects into the same block. If I first go to the block, go to a column inside the block, right click and create new blank column, double click on blank column to see formula bar, paste detail item into formula bar...that would work....

So in summary, this works after merging EmployeeID dimensions from 2 different universes...

[EmployeeID], [Name], [Address], (create blank column and paste: =[Title] in formula of blank column)

this does not work...

[EmployeeID], [Name], [Address], (drag [Title] into column next to [Address]) {Incompatible Object message appears}

If you create a details from the report side, all would work fine. You can merge all objects into same block without problems. I just don't understand why if a dimension has 10 details (and they are clearly attributes of a dimension) why can't these be done at the universe level and not have users recreate them at the report level.