abhijit.sahasardar

 Profile Answers by abhijit.sahasardar 

• Sep 14th, 2007

 

In WebI it is possible to create reports only from a universe and not from flat files

prashantpurohit2000

 Profile Answers by prashantpurohit2000 

• Mar 16th, 2009

 

Create two separate universes, first universe will be created using oracle and second from flat file. Then add 2 data providers in WeBI report and show the data together in a single report.

VigneshRajagopal

 Profile Answers by VigneshRajagopal 

• Jun 21st, 2011

 

Its possible

First add an query(query 1) and choose data source as universe(connection based on oracle client)
agian add an query(query 2) and choose data source as external data source and browse to the xls or any flat file which have a header and value and create an query

now in report,use merge dimension and join these two queries based on an common dimension and display the objects in same layout

Enjoy
Vignesh

karthik

• Oct 12th, 2011

 

as mentioned above... use webi rich client for flat file as one of the data source.

Anyone

• Oct 19th, 2011

 

Yes the 2nd one is possible only if it is R3(i.e external source).

Ankit Sahu

• Jun 18th, 2015

 

Yes it is possible to achieve this by using a merge dimension concept. Create 2 different queries for both the data providers and then create a merge dimension on a common dimension, and then create a single report .