Home > SAP software/management Tips > SAP tips and best practices > Retrieve BI data with Web Services
SAP Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

SAP TIPS AND BEST PRACTICES

Retrieve BI data with Web Services


Alexander Schuchman and Daniel McWeeney
10.09.2007
Rating: -3.80- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


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.

[IMAGE] Here is a custom made approvals application (no SAP standard approvals application). This displays all the CRM and BI data that is awaiting approval.
[IMAGE] This is the other half of the table (scroll to the right) that displays key items in the query.
[IMAGE] 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...


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
SAP tips and best practices
Minimizing business disruptions during an SAP upgrade or implementation
Retrieving content from an SAP workflow attachment
Updating URLs in SAP SRM
How to change default settings in SAP SRM
What are the benefits of implementing SAP SRM?
Increase column width in a transaction screen
Updating an RT table entry in SAP HR Payroll -- without the ADDWTE option
Is this the quickest way to find a BADI?
Adding custom fields for retail product comparisons in SAP BW
Improving performance with ABAP Objects in SAP Workflow

SAP NetWeaver tips
Using SAP NetWeaver MDM with CRM, SCM and NetWeaver BI
The importance of master data management following mergers and acquisitions
Designing your SAP NetWeaver master data management strategy
Enterprise MDM: SAP MDM for reducing data silos and duplicate records
How to move SAP NetWeaver Enterprise Portal between servers
Getting started with SAP NetWeaver PI (formerly XI)
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

SAP business intelligence tips
Choosing an SAP BI/BW database for InfoCube data
Using Infoset to join, move DSO analysis to InfoCube
Selecting InfoCubes in SAP BI/BW Business Content
How to limit employee access to reports using roles in SAP NetWeaver
SAP BI extractors vs. Business Objects for ETL process
Adding custom fields for retail product comparisons in SAP BW
Top 10 SAP tips of 2007
Adding special characters in SAP BI
Currency translation using SAP BI
How to acquire the runtime information of a data transfer process (DTP)

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


need to understand this to implement it. This is because the "queryEngine" offers a standard set of methods.
[IMAGE] 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.
[IMAGE] 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.
[IMAGE] 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




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.



NetWeaver SAP White Papers
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts