cancel
Showing results for 
Search instead for 
Did you mean: 

Combining data from different queries

former_member597137
Participant
0 Kudos

Hi guys,

I'm working on Webi 4.1 and I'm having some troubles to combine some data from different queries.

To make it simple, I have a list of ID in an excel file. I created 2 queries:

- one with the excel file to get this list of ID on a webi report (Query 1)

- a second one from the universe with the same dimenssion ID + a measure (Query 2)

But, when I run the queries and I create a report where I want to display the list from query 1 (the excel file) with the measure (from query 2), I have no values for the measure...

Column 1 | Colum 2

[Query 1].[ID] | [Query2].[measure]

My dimensions are merged, I don't see where is the problem..

Can you help please?

Thank you

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

is there any matching ID available in both the query where data is present in the measue object?

or in document summary tab->enable the option extentended merge dimension and see.