Skip to Content

Query as a Web Service, comonly known as QaaWS is a connectivity option provided by SAP Business Objects.  QaaWS tools provides users with an ability to create Web Services, these Web Services can be consumed from any tool or appliction which uses Web Services to fetch data.

QaaWS follows a Client Server architecture, wherein you have have a QaaWS Client tool residing on the users machine and a Server component where the actual QaaWS queries are stored

Below are step by step instructions for creation of QaaWS queries.

Before you can login in to QaaWS Client, you should have the Host details added. To do the same, click on the ‘Host’  button provided on the QaaWS login window.

The ‘Manage Hosts’ window shown below will open up,

Manage Host.jpg

Click on ‘Add…’ on the Manage Hosts window to add new Host details to the QaaWS client, the below “Edit a Host” window will open up. Add in the details,

Name: To Identify the Host. Name can be any name.

URL: The Web Service URL

CMS: Name of the CMS you wish to connect to

User: User details.

Authentication: This detail will be auto populated depending on the CMS you connect to and the authentication its using.

Edit Host.jpg

Once the Host details are added, the given host name will be visible in the drop down on the credentials window. Enter the relevant details and login to QaaWS

Select Credentials.jpg

Once inside QaaWS, you can create a new query, or edit or delete an existing one. To create a new query for this example, click on Query > New > Query…

QaaWS Client.jpg

A  Wizard window to Publish new Web Service will open up, where you can assign a name to the Web Service to be created. Add a description in the given description box

QaaWs Description window.jpg

You can click, on the ‘Advanced Parameters…’ window, if you wish to modify the details related to the Web Service, like Server its pointing to – in Web Service Base URL box. Set the session time out settings and the authentication mode

Advanced Parameters.jpg

To confirm the change, click ok. You will be back in the Credentials window, click Next on the Credentials window

As Step 2, the wizard window will place before you the list of available universe. To choose a Universe, on which you want to base your query

Select Universe.jpg

On completion of Step 2, in Step 3, all the objects from the selected Universe will be displayed. The Interface will be similar to the Web Intelligence query panel used for creation of Web Intelligence reports.

Choose the objects and set the filters, as per your Web Service design requirement

Query Window.jpg

The Step 4, will allow you to preview the various components of the query. Like the Input parameters like prompts, filters etc. Output parameters will be all the objects that you want to see data for.

At the lower bottom of the window, you will be able to see a sample preview of the data to be fetched to show the correcteness of the query.

Preview.jpg

If all the details in above window are as per your expectation, then you can click on ‘Publish’ to publish the query. The query will be saved on your server, and will be visible in the available queries listings in QaaWS client

In QaaWS Client, Click on your QaaWS query in the tree node listings on the left half of window, on right you will be able to see its WSDL URL. You can use this WSDL in Xcelsius Data connections to fetch data from the Universe.

QaaWS Client Node.jpg

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply