SAP BW Vs Universe

[Former Member]

Hi,

I was going through few posts on BOB regarding SAP BW. With SAP BW we can directly connect to warehouse without the universe with Bex queries. But if we can directly connect to warehouse why do we need to write the Bex queries, why can't i write a simple SQL. Also how it is use full over creating a universe to connect to database. And under which scenarios we should go for SAP BW over designing universe.

Thanks.

Thank You

[Former Member]

Hi Poonam,

BICS gives you a better performance when compared with Reports created using Universe on top of BEx Queries.

You can utilize BEx Structure, BEx Variables, etc.

When BEx Queries were modified, it will reflect in Report after refresh.

Don't need to export the universe after Changes.

Thanks

[Henry_Banks]

Hi,

the 'direct connection' is using BW's BICS API which goes to the BEx Query via the OLAP engine. 

If you want access to the relational table behind the Application servers concept of 'infoprovider' then you should use the BW-SQL multi source universe. (data federation) .

Please note, this by-passes Variables, hierarchies, etc etc.

Regards,

H