on 04-05-2012 8:28 PM
I have a report that I want to display data in from another query within the same universe. The I want to include a field in the report from the other query. I've merged dimensions between both queries on two related attributes both of which are displayed in the report. What I need to do is add an additional field in my report that displays [Scheduled Arrival Date] from query 2. The field should populate in the report where it matches with the merged dimensions query1.voyagenumber/query2.voyagenumber and query1.portofdebarkationcode/query2.locationidentifier. I tried creating a detail variable a couple different ways but have been unsuccessful. What dimension/detail variables do I need to build in order to get [Scheduled Arrival Date] to display in the report where is corresponds with the merged dimensions?
Hi,
You were going in the right direction with the report-level variable.
Your formulae with need an If Then Else statement.
Regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Where am I creating the If..Then..Else? In the detail variable I created that outputs the Scheduled Arrival Date, I use just associated the detail variable to the merged dimension [LocationIdentifier]. For some I did get an output in the report. There are others that I am getting a #MULTIVALUE which I guess would indicate there is more than a single matching result even where I merged the dimensions. When I look at the results from the query however, I am not seeing any duplicate results.
Where am I creating the If..Then..Else? In the detail variable I created that outputs the Scheduled Arrival Date, I use just associated the detail variable to the merged dimension [LocationIdentifier]. For some I did get an output in the report. There are others that I am getting a #MULTIVALUE which I guess would indicate there is more than a single matching result even where I merged the dimensions. When I look at the results from the query however, I am not seeing any duplicate results.
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.