Retrieve BI data with Web Services

	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.

Rate this Tip To rate tips, you must be a member of SearchSAP.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT SAP best practices Top 10 SAP tips of 2007 Eliminate database read/write times with ABAP shared memory Model-driven development in the enterprise Budgeting Best Practices with SAP Business Planning -- Part II Budgeting best practices with SAP business planning Currency translation using SAP BI How to acquire the runtime information of a data transfer process (DTP) Smart Forms vs. PDF-based print forms in SAP solutions -- pros and cons Defining shared services and shared outcomes in the public sector Repair bad SAP data and subsequent data targets with delta update SAP NetWeaver Top 10 SAP tips of 2007 Eliminate database read/write times with ABAP shared memory XI: Search through the payload of a message... without TREX! Using Folders in PI 7.1 User management with SAP NetWeaver Administrator Business process platform creation for healthcare, part 2 Business process platform creation for healthcare How to acquire the runtime information of a data transfer process (DTP) A process runtime dashboard for tracking efficiency SAP XI - Event based message triggering with dependencies Business Warehouse Top 10 SAP tips of 2007 Adding special characters in SAP BI Budgeting best practices with SAP business planning Currency translation using SAP BI How to acquire the runtime information of a data transfer process (DTP) Smart Forms vs. PDF-based print forms in SAP solutions -- pros and cons Repair bad SAP data and subsequent data targets with delta update Real-Time Data Acquisition - BI@2004s SAP BW Guide: Open Hub Service How to integrate BW query iViews with a WebDynpro application RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary 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.