Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Merging dimensions

I am using merged dimensions in a report to link together data from 2 
queries. 

In the first query I have this data showing when a customer has cut a 
license for a product 
Query 1 
======= 

Email address         Date license cut 

fred@this                01-jan-08 
jim@that                 07-feb-08 
tom@wherever        10-mar-08 
etc 
in the second query, I have data of the count of the executable 
downloads done 

Query 2 
======= 

Email address           Executable download count 

fred@this                  3 
jim@that                   1 
sue@somewhere    	2 

I have merged on email address. 

People may have cut licenses only, downloaded only or downloaded and cut 
licenses. 

What *appears* to happen is that I get *all* the lines from the first 
query and so the download count is empty for "tom" above, but not those 
lines from the second query that are not in the first. So no entry for 
"sue": 

Email address   Date license cut        Download count 

fred@this               01-jan-08               3 
jim@that                07-feb-08               1 
tom@wherever       10-mar-08               <empty> 

What I want to do is to get all the lines from both queries: 

Email address   Date license cut        Download count 

fred@this               01-jan-08               3 
jim@that                07-feb-08               1 
tom@wherever       10-mar-08               <empty> 
sue@somwhere      <empty>                2 

Please advise

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question