How to use Analysis for Exel in SSO ?

[former_member644785]

Hello,

For the moment we have only few users which use Analysis for Excel because they have to enter their login & password.

We'd like to install Analysis for Excel for a larger population.

Do you know how to implement SSO in Analysis for Excel (as in BO Web) ?

Thank you in advance

Regards,

Nicolas

[mhf]

Hi Nicolas,

please refer to the following SAP Note:

http://service.sap.com/sap/support/notes/1646920

Regards,

Michael

[former_member644785]

Hello Michael,

Thank you very much for this note.

We tried to implement it in our test environment but unfortunatly we get an error message.

Do you have any idea ?

Thank you in advance for your help.

Regards,

Nicolas

[mhf]

Hello Nicolas,

is WinAD SSO already configured correctly in your environment? So is it possible to login to the BI Launchpad via WinAD SSO? If not then you have to configure and activate it.

Regards,

Michael

[former_member644785]

Hello Michael

Yes, our customers can use BI Launchpad in SSO.

We'd like to have the same logic for Analysis for Excel.

Thank you in advance.

Regards,

Nicolas

[manna_das]

Hello Nicolas,

Use the following steps :

Step 1

Locate the File “global.properties”

Drive:\SAP BusinessObjects\Tomcat6\webapps\BOE\WEB-INF\config\custom

The following values should be present:

• vintela.enabled=true

1. idm.realm=Domain Name (u can get the name from C:\Windows\Krb5.ini)
2. idm.princ=SPN User
3. idm.allowUnsecured=true
4. idm.allowNTLM=false
5. idm.logger.name=simple
6. idm.logger.props=error-log.properties

Step 2:

Locate the file “web.xml”

D:\SAP BusinessObjects\Tomcat6\webapps\dswsbobje\WEB-INF

Uncomment the Kerberos Proxy Filter and the Kerberos Filter sections to enable Kerberos SSO for Windows Active Directory (secWinAD) authentication. The following options must be specified (the rest are optional)

• idm.realm = SPN user (the same as the default_realm specified in the Krb5.ini file)

• idm.princ = SPN User (the same as specified for idm.princ in the global.properties)

• idm.keytab = (the same as specified for idm.keytab in the global.properties )

Please note, if you are using the hardcoded password set in Tomcat's Java Options do not make any changes to the keytab lines in the web.xml

Step 3:

Backup and edit Drive:\Tomcat6\webapps\dswsbobje\WEB-INF\classes\dsws.properties by setting kerberos.sso to 'true' Restart Tomcat

KR,

MD

[former_member644785]

Hello,

Thank you for your feed back
We've checked every points but now we have this errror message :

Do you have any idea ?

Thank you in advance for your help.

Regards,

Nicolas