Skip to Content
author's profile photo Former Member
Former Member

Single Report from two different universe

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


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Feb 28, 2017 at 09:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded