Multiple Universe for a Report

[Former Member]

Hi

We have three universes Sales based, Customer based and Material based. We have three reports connecting the relevant universe. Now i want to build one Main report on Finance using all the above 3 universe and adding one more Financial based Universe. How can i connect and make them interact with each other in the main report ? All the above universe belongs to one business Unit.

Regards

Siva

[former_member184594 · Accepted solution]

You can use more then one universe in a WebI report. In Query Panel, click on Add Query button and select From Universe. After that, select the universe you want to use on the report.

[Former Member]

Hi,

You can add multiple universes to a single report by using "Add Query" Option. And in the report level use "Merge Dimension" to merge the objects(dimensions) from different universes, this enables you to use the objects of different queries in the same report.

Regards

Subasree