How to start Query as a Web Service

This kind of query  is useful because can be used it to consume data into Xcelsius Dashboards in alternative to connecting through Live Office.

See:
Sap BO Dashboards 4.0 - Xcelsius 2008

Query as a Web Service is used with a Central Management System (CMS)

The CMS contains the server component that stores the Query as a Web Service catalog and hosts the published Web Services.
When you start Query as a Web Service for the first time, you must define the host server before starting.
Each successive time you start Query as a Web Service you select an available host server, then log into the CMS.
Once you are logged in, the Query as a Web Service startup Query Catalog page appears.
 From this page you can start the query creation and publication wizard to publish a new query and edit existing published queries.



How To define a query in Publish as a Web Service Wizard

The "Query" page of the "Publish as a Web Service Wizard" allows you to use a query panel to define a query based on a universe.
The query panel is based on the "Web Intelligence HTML Query Panel". The query panel is described briefly in this section with instructions to build a query, however, the query panel is fully documented in the guide Building queries with Web Intelligence Query - HTML.
You should refer to this guide in the documentation for this release for more information.



QaaWS has limitations when creating a query: 

- Multi-cubes cannot be used
- Combined queries and subqueries cannot be used
- IndexAware prompts are not implemented

Also, keep in mind that the name of the Web Service and its metadata are encoded to support various programming languages (such as C#, Java, C++, VB, Flash).

Limitations at query run-time

- Object restrictions cannot be used Query






The better solution for loading data into Xcelsius dashboard

is represented by QaaWS in case of the data source allows:
a good time response, that could be about 10 seconds
the data layout and format allow to  be easly and straightful used in the dashboard
the dataset of the query result is small.

Otherwise you could use Live Office connection in the case of :
your Queries response is very poor or you need to do data calculations  such as sum, avg, grouping and so on. 
In these case the best solution is the schedule the Webi report in order to have a quick access to scheduled data by connecting to them through Live Office.

 See also:

Consuming a query as a web service in Xcelsius

QaaWs and customized Authentication in Xcelsius



Comments

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP BusinessObjects 4.0 - Suite Presentation

Image
The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E
Read more