Quick and Dirty Guide to Creating a QaaWS

Mike Allison —  March 20, 2009 — 4 Comments

With Query as a Web Service (QaaWS) becoming such a hot topic and being such a powerful tool, I figured that creating a quick cheat sheet on how to create one would be beneficial to all developers/users using this product. Check out below the steps needed to create your very own QaaWS.

*Note: This guide has been created using SAP Business Objects XI 3.1. Older versions of Query as a Web Service may look and function differently.

Getting Started

To get started we will need to first have the QaaWS Client Tool installed and have access to your SAP Business Objects (BOBJ) repository information. The client tool can typically be found in the following path: Program Files > Business Objects XI 3.1 > Client Tools > QaaWS.

When launching the tool for the first time, you will be prompted to set up a host definition. To do this you will need the following information: Server name, Central Management System (CMS) name and your BOBJ login information.

 

Adding a Host

As you see above, when you enter in the Host name / Server name the  URL will be automatically populated and should look something like this: http://<Server Name>:8080/dswsbobje/services/Session. Once you entered the Server name, the URL that gets generated will be validated against the server to make sure that it is responding. Enter in the CMS Name and your BOBJ user id and your host definition will be complete. Now you can provide your BOBJ login credentials and sign into QaaWS.

Creating a QaaWS

After logging in, you now can go ahead and create your QaaWS.  The steps to create and publish your QaaWS are as follows:

  • Add a New QaaWS
  • Name your QaaWS
  • Select a Universe <– Click for more information on Universes
  • Create a Query
  • View Example Set of Data
  • Publish your QaaWS

Adding a New QaaWS

There are two ways that you can create a new QaaWS. The first is to click Query and choose New -> Query. The second is to right click on any folder and click New Query.

Adding a New QaaWS

Adding a New QaaWS

* Note: You can Add Folders and Edit, Duplicate, Delete, Rename, Cut, Copy, or Paste your QaaWS/Folders.

Name Your QaaWS

After Creating your QaaWS you will need to provide a name for it on this screen to continue.

Name Your QaaWS

Name Your QaaWS

Also on this screen, you can enter a Web Service Description or look at advanced properties to change the base Web Service URL, Session Time-out, and Authentication mode as shown in the image below.

Advanced Properties
Advanced Properties

Universe Selection

Select the Universe that accesses the data you want to use in your QaaWS.

 

Select a Universe

 

Query Creation

Now it is time to select the data you want to have available in your QaaWS. This page should look familiar to anyone who has used Web Intelligence or pulled data into a Crystal Report using a Universe as a Data Source. Just like in WebI you can select the Objects you want to display and select filters or create prompts to limit your data set.

 

Create a Query

 

A couple other functions that are available on this page pointed out by the red arrow are: Adding a Ranking, Defining a Sort and,  options such as Duplicate Rows, Fetch Time and Rows Retrieved.

* Note: If you have a prompt in your query filter, you will need to provide values to move on to previewing your data. See Image Below.

Answer a Prompt

Answer a Prompt

Preview Your Data

Once you have selected your data and filters, a preview of this data will show up so you can see what will be provided in the QaaWS.

Preview Your Data

Preview Your Data

* Note: Data preview is limited to 50 rows

Publish Your QaaWS

After you preview your data, you can click on Publish and make your QaaWS available to any application that can consume a Web Service.

Published Web Service

Published Web Service

Wrap Up

In a couple of steps, we were able to go ahead and make our data available as a Web Service. This live connection can be used in fueling apps such as a Xcelsius Dashboard or even a Crystal Report.  We will be diving into both of these topics in upcoming blogs. Check them out when they become available!

Mike Allison

Posts

Mike Allison is a Managing Consultant with Altek Solutions.

4 responses to Quick and Dirty Guide to Creating a QaaWS

  1. I have published a webservice using Qaaws, it provid me wsdl url.but I Donmt know what to do next.How to Provide that data to client using this webservice.Please reply me soon

  2. Mike,
    this article very helpful for me, but my question is I couldn’t connect to my CMS (Crystal Report Server XI SP3). I tried to direct connect the URL http://localhost:8080/dswsbobje/services/session, but it’s failed. can you let me know how to enable this service ?

    Thanks

Trackbacks and Pingbacks:

  1. Altek Solutions Blog » What is Query as a Web Service (QaaWS)? - March 20, 2009

    […] If you want to know more about how to create a QaaWS check out my Quick and Dirty Guide for Creating a QaaWS. […]

  2. Altek Solutions Blog » Using QaaWS to drive your Xcelsius Dashboards - June 11, 2009

    […] right in line with the other blogs that I have written about QaaWS (What is a QaaWS and Quick and Dirty Guide to Creating a QaaWS) I decided to put together a quick one and a dashboard to show how to leverage your Business […]

Leave a Reply