Skip to Content
Author's profile photo Ingo Hilgefort

BusinessObjects and SAP Part 9 – Xcelsius with Crystal Reports and Live Office

In case you missed my previous blogs here a quick overview: | Part #1 |  [BusinessObjects and SAP Part I | BusinessObjects and SAP Part I] | BusinessObjects and SAP – Overview | | Part #2 | [BusinessObjects and SAP Part 2 | BusinessObjects and SAP Part 2] | Crystal Reports and BI Queries | | Part #3 | [BusinessObjects and SAP Part 3 | BusinessObjects and SAP Part 3] | Crystal Reports and BI Hierarchies | | Part #4 | [BusinessObjects and SAP Part 4 | BusinessObjects and SAP Part 4] | Crystal Reports and SAP R/3 | | Part #5 | [BusinessObjects and SAP Part 5 | BusinessObjects and SAP Part 5] | Web Intelligence and SAP BI | | Part #6 | [BusinessObjects and SAP Part 6 –  Web Intelligence and SAP BI | BusinessObjects and SAP Part 6 –  Web Intelligence and SAP BI] | Web Intelligence – Delegated Search and Delegated Measures | | Part #7 | [BusinessObjects and SAP Part 7 – OLAP Universe change management | BusinessObjects and SAP Part 7 – OLAP Universe change management] | OLAP Universe Change Management | | Part #8 |  [TechEd Las Vegas – Are you up for the Business Objects Community Xcelsius Challenge | TechEd Las Vegas – Are you up for the Business Objects Community Xcelsius Challenge] | Xcelsius Overview | To continue my blog series around BusinessObjects on top of a SAP landscape I will explain this time how you can leverage Crystal Reports and Live Office to connect to SAP data sources and leverage this connectivity inside of Xcelsius to create a dashboard. Lets assume we created a BI query on top of the cube DALSEGNO And we created a report using Crystal Reports showing the following data…… The report is showing the products and the Sales amount broken down by month. After I saved the report to BusinessObjects Enterprise  I can now start Microsoft Excel with Live Office and create a new Live Office document connecting to the Crystal Report document. I navigate to the menu *Live Office > Options* to configure my authentication. At the “Enterprise” tab I select the option “Use specific logon criteria” At the web service URL I enter the URL in the syntax http://APPSERVER:PORT/dswsbobje/services/session (http://appserver/dswsbobje/services/session) where the APPSERVER and PORT stands for the server where you deployed the web service from BusinessObjects Enterprise. As Authentication method I am selecting “SAP” so that later on I can achieve Single-Sign-On from the Xcelsius Dashboard to Live Office and the Crystal Reports object. Use your SAP Credentials in the format [System ID]~ (Client)/[Username] to authenticate (exampleCIM~003/i819882) Now I can select the menu *Live Office > Insert > Crystal Reports* content Because I configured SAP as the authentication method I can use my SAP Credentials in the format (System ID)~[Client]/[Username] to authenticate (example : CIM~003/i819882) After I authenticated I can select the previously created report from the BusinessObjects Enterprise system and leverage the wizard to receive the data  from the Crystal Report object inside of Live Office. Now I select the menu *Live Office > Publish to BusinessObjects Enterprise > Save to BusinessObjects Enterprise*  to save the newly created Live Office document to BusinessObjects Enterprise. Now I can start the Xcelsius Designer and create my new dashboard. As first step I configure my data connectivity and select the menu *Data > Import from Enterprise.* I am logging on to my BusinessObjects Enterprise system. And select the previously created Live Office document Now I need to configure the details of my connection in the Data Manager. To do so I select the menu *Data > Connections*.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.