Performance impact if data modeling is done in Universe (instead of Oracle DB)

[tkim1205]

Hi all,

Situation:

I have 2 scenarios - one where client has their data in an Oracle Database, and the other where their data is on HANA Database.  Both of them want to build Universes and report on the data with BI tools.

Question:

Is there performance impact if data modeling is done in the Universe layer, instead of the Database layer?

Example:

If 2 tables are joined in a Universe, and we execute a query on that Universe, does the Database join the 2 tables and send the result data back to the Universe, or does Universe get the 2 datasets separately, and join them together on the BOBJ server?

Thanks,

Tony

[Former Member · Accepted solution]

Hi Antony,

I Can answer for Universe on Oracle Database.

When you create a universe, you specify the Tables their joins inside the Universe.

While running a report, an SQL Query is generated automatically based on the universe.

And this Query will be run on the DB and the resultant dataset will be forwarded to WebI Report.

So there should be no problem if the Data modelling is done in the Universe.

Regards,

Rajesh

[tkim1205 · Accepted solution]

Thanks Rajesh!