cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Dimension and Detail Variables To Display Data in a Single Report From Multiple Queries

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

You were going in the right direction with the report-level variable. 

Your formulae with need an If Then Else statement.

Regards,

H

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi John,

Please have a look at kbase https://service.sap.com/sap/support/notes/1339858

Thanks,

John

Former Member
0 Kudos

That link does not appear to be working when I try to go to it.  I just get a page cannot be displayed.

Former Member
0 Kudos

Please have a look at kbase 1339858.  That's what the link was for.

Thanks,

John