on 06-28-2019 10:13 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.