Skip to Content
avatar image
Former Member

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

Hi Experts,

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

Req:

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:

12654798
14623857
99999999

Similarly Proj-id tab of excel has data say:

10.45698.3247
16.25897.1465
19.99999.9999

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.

Problem:

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?

Thanks,
Deep

req.jpg (22.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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 object.rest all objects create as detail of WO Num merged dimension.

    Add comment
    10|10000 characters needed characters exceeded