Universe Connections for SAP BEx

[Former Member]

Hi All,

We are planning to build couple of Universes over SAP BEx query.

Could anyone inform if we should go for creating a single connection and use it for all Universes (or) Create multiple connections.

Does having different connections for different Universes(though Data Warehouse-BW) is same helps in increasing report performance?

Thank you.

- AK

[IngoH · Accepted solution]

Hi,

a universe is based on the BEx query and each connection is pointing to a single BEx query.

building a "super query" is not a good idea as you will get performance issue.

here s some material:

/people/ingo.hilgefort/blog/2010/07/29/dear-abi--performance-improvements-for-web-intelligence-in-combination-with-sap-netweaver-bw

Ingo

[Former Member · Accepted solution]

Thank you all for clarifying.

- Anil

[Former Member · Accepted solution]

Ingo,

1) One more question, will creating merge dimensions in WebI on SAP OLAP Universes reduce performance?

2) Secondly, if we are not planning for Super BEx query --> Super OLAP universe, then we have to create multiple small

queries. Which results in multiple WebI queries in repository.

I believe it will cause maintenance overhead such as managing WebI report instances.

Regards,

Anil

[Former Member]

Hi Anil Kumar,

This ans may be help for you,

Universe links two methods,i.e: linking and include. when we are working on linking or include universes there most be use single connection, where we pass universe to derived universe from core universe.because of different connections have maintain the non related data and relationship in data base.

Thank you,

praveen.

[former_member793810]

Hi,

It all depends on your requirement. There are few ways.

You can create one super universe on the top of your BW Query and then create your reports using your super universe.

Or you can create multiple universes and then create your reports.

Basically one universe one connection. SAP Universes are different then other universes where you create one connection.

In SAP environment one universe one connection.

Hope it helps.

Regards,

Bashir Awan