1482030 - SSO for Live Office connection does not work in Xcelsius Designer during Preview

SAP Knowledge Base Article - Public

1482030 - SSO for Live Office connection does not work in Xcelsius Designer during Preview

Symptom

  • SSO (Single Sign-on) for Live Office connection does not work in Xcelsius Designer during Preview.
  • User is challenged with an authentication box when the model Preview is done.

Environment

  • Xcelsius 2008 Enterprise
  • BusinessObjects Enterprise XI 3.1

Reproducing the Issue

  1. Enable Windows AD SSO use in Live Office (see Reference section below).
  2. Insert a Web Intelligence document in Excel using Live Office.
  3. Import this Excel into Xcelsius.
  4. Go to Data Manager and map this Live Office connection. In Definition tab, set correct 'Session URL' and in Usage tab, set as 'Refresh Before Components Are Loaded'.
  5. Choose appropriate component to design a model based on Excel data.
  6. Preview this model, notice that authentication box pops-up. (SSO does not work)

Resolution

  • It is an expected behaviour to get the authentication box. Experience when clicking the 'Preview' is similar if this .SWF dashboard is exported locally onto Desktop and opened in a browser.
  • Further, it is a limitation that Win AD SSO is not supported as a standard for SWF. In order to authenticate against the Enterprise, it is expected to give System Name, User Name, Password, Authentication Type information in the authentication box.
  • Product Group is aware of this and may consider design enhancements in future release of the product.

Note: In Xcelsius, when you go to File > Export > SAP BusinessObjects Platform, in the authentication box type the "system name" and choose Authentication type as "Windows AD" and click on "OK" - it works if Win AD SSO is enabled. But this functionality and the workflow is different to that mentioned in the Symptom section in this Knowledge Base.

Other scenario when SSO should work:

  • File > Open from Platform
  • File > Save to Platform

Keywords

cx, crystal, LDAP, kerberos, vintella, LO, dashboard, qaaws, dswsbobje, web service, webservice , KBA , BI-BIP-AUT , Authentication, ActiveDirectory, LDAP, SSO, Vintela , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008