cancel
Showing results for 
Search instead for 
Did you mean: 

Single Report from two different universe

Former Member
0 Kudos

HI Guru ,

I have a requirement

I have to create a single report with two Universes

1) Universe A Contains Data from jan 2015 to Dc 2015

2)Universe B Contains Data from jan 2016 to Till now

I want to see Both universe(A+ B) data in Single report .

I guess i can achieve the same by using merged dimension

but have few questions do i will be getting Duplicates issue and what changes i have to do in the reports.

Thanks in advance

Sinha

View Entire Topic
amitrathi239
Active Contributor
0 Kudos

You can use merged dimension at report level to get data from both the queries.I don't think so you will get duplicates records as in both the queries data range is different.

You need to merge the dimension objects and for measures use sum function to display in single column.

Former Member

Thanks Amit Sir