Best Pratice on OLAP Connections

[Former Member]

Hello Experts,

I 've been trying to learn BO and have came across one doubt.

What is best practice to create OLAP connection (BICS Connection), meaning ,

1. Does we have to use single OLAP connection to all BO reports OR

2. Create new OLAP Connection for each BO Report we develop.

What is impact on each of above point. I have tried to seek an answer on this question on SDN but most nearst answer I got it , "it is depends on design" but I would like to understand its porns n cons for better understanding.

Does someone share an knowledge on about points ?.

Thanks,

[IngoH · Accepted solution]

Hello,

in case you are using already naming conventions in BW as part of the authorizations you can leverage a single OLAP connection as then SSO will use the authorizations and the user will only receive the list of cubes and queries that have been set using the authorizations with naming conventions

in case you do not use naming conventions in BW I would recommend to create several connections on  a InfoProvider level and define security on the BusinessObjects Server for the roles as otherwise a user might be able to see a cube and query (not the data !) and tries to open a cube that he is not allowed to see.

Ingo Hilgefort, SAP

[Former Member]

Hi,

In addition to Henry's comments: Most of my customers decide on using one single OLAP connection to a BW System. This way you do not have to create new connections often, this activity creates some overhead for your implementation team.

Available options:

• One OLAP Connection to a BW System, you select all your BEx queries.
• One OLAP Connection to an InfoProvider, you can select all BEx queries on top of the selected InfoProvider
• One OLAP Connection to a BEx Query, you can select only one particular BEx query

From a functional pespective there are no differences: All connection options allow you to connect to BEx queries.

Best regards,

Victor

[Henry_Banks]

Hi,

it's up to your project's proference:

You can have 1 OLAP connection pointing to a single BW SID system (hence, all bex queries)

or you can have an OLAP connection for each and every BEX Query

Regards,

H