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
-
Create a Live Office sheet.
-
Bring the data into Live Office from a Crystal report.
-
Save the sheet. Import the same sheet to Xcelsius.
-
Build the model in Xcelsius and configure the Live Office connection.
-
Publish the Xcelsius dashboard to Enterprise.
-
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
-
Open the Live Office sheet which is being used by Xcelsius.
-
Go to Live Office tab.
-
Select the "Option" menu from the Live Office tab. A window appears with three tabs: General, View, and Enterprise.
-
Click the Enterprise tab.
-
Check the "Use Specified logon criteria" option.
-
Fill in the login credentials. Click OK.
-
Save the Excel sheet. Re-import the same sheet to Xcelsius.
-
Save or publish the file to Enterprise.
-
Preview the dashboard in Enterprise.
It will no longer prompt for login information.
Keywords
Xcelsius 2008, Authentication, Live office , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To
Product
SAP BusinessObjects Xcelsius Enterprise 2008