BusinessObjects and SAP Part 9 - Xcelsius with Cry...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
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*.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.