Single Report from two different universe

[Former Member]

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

[amitrathi239 · Accepted solution]

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 · Accepted solution]

Thanks Amit Sir