Expand +



Quick overview of Web Service Queries for dashboards - Tip from SAP BusinessObjects Dashboards Bootcamp

by The Tip Doctor

November 26, 2012

Query Browser is according to Roy Wells’ session at Xcelsius Dashboard Bootcamp the “easiest to use and maintain” and the first choice when connecting to BW.  How does this compare to Web Service Query (previously known as Query as a Web Service)?

This tip compares the two types of Web Services queries, excerpted from a session presented by Roy Wells of Decision First Technologie at SAPinsider’s Xcelsius Dashboards Bootcamp seminar.

The session “Connecting Your Dashboard to Back-End Data Sources: A Comprehensive Guide”  took attendees step-by-step through setting up a query with various options  selecting the right connection type, and best practices.

This tip takes a quick peek at an overview of these two connection options.

Overview of SAP BusinessObjects Connections 

1. Provided out of the box

  • New in SAP BusinessObjects Dashboards 4.0 Query Browser Connection
    • ?Universes or BEx queries
  • Web Service Query (formerly Query as a Web Service)
  • Live Office Connections
  • Crystal Reports Data Consumer
  • SAP NetWeaver BW Connection

2. Available as an add-on

  •  SAP EPM 7.5 Extended Analytics Analyzer

Web Service Query options

  • Two kinds of query are available:
    • Query as a Web Service
    • BI Service

  • Both kinds are based on SOAP Web Services and are serviced via the SAP BusinessObjects Web Services application
  • Can be consumed by ANY application that supports SOAP, including SAP BusinessObjects Dashboards
  • Comparing the two types
    • Query as a Web Service allows access to a single query data provider
    • Queries are built using the QaaWS client tool
  • BI Service provides access to an SAP BusinessObjects Web Intelligence (WebI) block, including merged dimensions and variables
    • Obsoletes Live Office connections
    • Queries are published from a WebI document
  • Advantages
    • Quick execution times
    • Flexible input parameters for filtering data
    • Can separate table data from headers and footers
    • Specific to BI Services
      • ?Support for Scheduled Instances
      • ?Support for Cross Tab data blocks
      • ?Support for merged dimensions and report variables
  • Disadvantages
    • Web Service Query creation happens in external applications
    • Web Service Query creation and implementation is technical
  • Recommendations for Web Service Queries
    • If you are connecting to a universe and you need merged dimensions or access to scheduled instances, use it
    • If you need report-level variable calculations, possibly use it to avoid putting calculations in Excel using Query Browser

An email has been sent to:

More from SAPinsider


Please log in to post a comment.

No comments have been submitted on this article. Be the first to comment!