Skip to Content

How to show two merged dimension from different query into a single report?

Sep 24, 2017 at 02:03 PM


avatar image

Hi Experts,

I need your help in catering to a specific client requirement which is as below:


all the fields are available in the universe. But the report will run on inputs of
WO's and Proj-id's from an Excel file whose data will change as per users discretion.

i.e we will create three queries total,
1st query - based on excel 1st tab WO tab. bringing in WO nums
2nd query- based on excel 2nd tab Proj-id tab, bringing in Proj-ids.
3rd query- based on universe, having two query filter:
WO num = Query 1. WO
Proj-id = Query 2.WO

How users excel looks like: The excel will have two tabs : WO tab and Proj-id tab.

WO tab will contain a list of WO say:


Similarly Proj-id tab of excel has data say:


Now, 1st two WO's as listed in the excel reside in database, but 99999999 not a valid WO
similarly ,1st two Proj-id resides in database and 19.99999.9999 is also not a valid Proj-id.

So, the requirement is to show those WO's from the users list which reside in the database and also those which are not.
Same goes for Proj-id.

Users can run the report with any random WO list. and /or any random Proj-id's.


To cater to the requirement above , I merged Query1.WO with Query3.WO ,
also, Merged Query2.Proj-id with Query3.Proj-id.

WO merged dimension is returning all the WO's and Proj-id merged dimension is returning all Proj-id's. But I cannot show them together like the requirement.

Can anyone please help?


req.jpg (22.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sep 24, 2017 at 02:21 PM

in the webi document properties select option extended merge dimension.

After that drag WO num object from query 1 and query 2 Proj I'd all objects create as detail of WO Num merged dimension.

10 |10000 characters needed characters left characters exceeded