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