Retrieve BI data with Web Services

Retrieve BI data with Web Services

Alexander Schuchman and Daniel McWeeney
This tip will display BI information at the same time as CRM information in the BSP application (an HTMLB table). This enhancement does not require dual maintenance of business logic in BI because business logic changes are made within the query and not in the BSP application.

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

 Here is a custom made approvals application (no SAP standard approvals application). This displays all the CRM and BI data that is awaiting approval.
This is the other half of the table (scroll to the right) that displays key items in the query.
The simplicity of this lies in the fact that one developer can build this web service framework to allow queries to be called in the instances. This means that the rest of the developers in the company do not need to understand this to implement it. This is because the "queryEngine" offers a standard set of methods.
The information needed to provide a query in BW is in this image. This is where you hard code a cube name and a query name.
This image shows the process of setting a variable input for the query in order to get the resulting data set as a complex data structure.
Logical port definition uses an SSO logon ticket: An end user authenticates with Portal which generates an SSO2 Ticket and this Ticket is passes the user credentials from CRM to BI.

Create and Release the Web Service in the BI System: Release the service after you do the transport and don't forget to reactivate the security aspect it in SICF.


This was first published in October 2007

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top