SAP Knowledge Base Article - Public

1270267 - Previewing the dashboard based on Live Office in InfoView prompts for login information

Symptom

Dashboard based on Live Office is prompting for authentication when trying to preview from InfoView.

Environment

Product: Xcelsius 2008, Live Office, BusinessObjects Enterprise.

Service Packs/Hot fix: SP1 for Live Office and Xcelsius 2008.

Operating System: Windows XP Professional, Window Enterprise server 2003.

Office: Microsoft Office 2003.

Reproducing the Issue

  1. Create a Live Office sheet.
  2. Bring the data into Live Office from a Crystal report.
  3. Save the sheet. Import the same sheet to Xcelsius.
  4. Build the model in Xcelsius and configure the Live Office connection.
  5. Publish the Xcelsius dashboard to Enterprise.
  6. Try to preview the model from Enterprise and it will prompt for login information before previewing.

 

Cause

The Live Office connection setting is not provided with the Enterprise Authentication.

Resolution

  1. Open the Live Office sheet which is being used by Xcelsius.
  2. Go to Live Office tab.
  3. Select the "Option" menu from the Live Office tab. A window appears with three tabs: General, View, and Enterprise.
  4. Click the Enterprise tab.
  5. Check the "Use Specified logon criteria" option.
  6. Fill in the login credentials. Click OK.
  7. Save the Excel sheet. Re-import the same sheet to Xcelsius.
  8. Save or publish the file to Enterprise.
  9. Preview the dashboard in Enterprise.

It will no longer prompt for login information.

 

Keywords

Xcelsius 2008, Authentication, Live office , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008