Merging dimensions

[former_member188062]

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

[Former Member · Accepted solution]

Hi Simon,

Try including all the dimensions in the report, especially include both the merged dimensions and then hide any on of them.

Then you will be able to see all the lines from both the dimensions. Hope this helps.

Regards,

Sanjay

[Former Member]

Hi,

You need to use the merged dimension object in the report. You will see it in Webi.

Hope this helps

Jacques