Skip to Content
1
Former Member
Jan 20, 2016 at 04:51 AM

How to create Multisource Universe

22 Views

Hi Experts,

We have a Two Databases one is oracle and another Teradata.

Which two databases are having same tables with same data structure. We need to
create a web intelligence Report with sub-reports on top of the both databases.
Our customer suggest that to create a multi-source Universe. If we pass the
Parameters between start date and from date the report going retrieve the
data among date basis which belongs to different databases. It is possible to
create multisource universe for this scenario. If it’s yes how to create joins between

both databases which having sametables or we need to create a derived table for joining

the tables in the universe.Please suggest us for correct solution to Proceed.

Thanks in Advance