1 User for all OLAP Connection and not authentication for SAP BW

[Former Member]

Hi Gurus,

I'm using SAP BO OLAP Analysis for Excel.

When I connect to SAP BW by Analysis on BOE Server, I have to enter the user/pass of SAP BW. I configured the SSO for BOE and SAP BW, and it's working. By this solution, I have to map each BOE User for each SAP BW user.

Now, I want to use 1 SAP BW user that I can connect to BW from Analysis and I don't need to enter user/pass.

Please give me the solution for this case.

Best Regards,

Hoa.

[TammyPowlas · Accepted solution]

You can set up a predefined user in the OLAP connection.

There are several videos on the OLAP connection here: and

[Former Member · Accepted solution]

Thanks Tammy,

I'm using this method. But it will show a dialog and I still have to enter the bw user.

[TammyPowlas · Accepted solution]

Can you share screen shots of how the connection was set up in the CMC? Which version of the BI platform are you using?

[Former Member · Accepted solution]

Hi Tammy,

I'm using BIP 4.1 SP06 and SAP BW 7.01 EHP1

And this is my config.

[TammyPowlas · Accepted solution]

That is really strange; thank you for the screen shot.

That should work.  I would open an SAP Incident with SAP Support to review the situation...

[Former Member · Accepted solution]

Thanks Tammy.

I will open SAP Incident too.

[former_member193885]

Please refer to the AO Admin guide below.

"When you create a new connection with the module OLAP Connections, you should not use authentication type Pre-defined because the pre-defined user (and password) is not exposed to local clients such asAnalysis."

Creating and managing BW system connections in SAP BusinessObjects Business Intelligence - Getting S...