Setting up Interactive Portlets › Set up the QaaWS Connection to Xcelsius Visualizations

Set up the QaaWS Connection to Xcelsius Visualizations

Use these steps if you are using the QaaWS connection method to establish real-time data transfers between CA Clarity PPM and the Xcelsius visualization.

Users who view Xcelsius visualizations that transfer data using the QaaWS connection method must be members of the following Business Objects security groups:

• QaaWS Group Designer
• Universe Designer Users

To set up QaaWS as the connection method

1. In the Query as a Web Service tool, create the Query. Do the following:
   1. Enter a description for the Web Service.
   2. Select a Universe.
   3. Drag and drop Universe objects and classes to create the Query.
   4. View the web query WSDL URL associated with the query you created for your interactive portlet. Make note of the URL of the query.
2. In Xcelsius, open the Data Manager and set up the web service to establish the connection with CA Clarity PPM.

   Note: See the BusinessObjects Xcelsius 2008 User Guide for more information.

   1. Complete the following fields:

      WSDL URL

      Defines the URL of the web service to import the URL.

   2. Map Output Values of the web service to the appropriate cells in the spreadsheet.
   3. Create the following Flash variables. The names used to define these Flash variables are mapped to the interactive portlet as global and object parameters:
      • Session ID. Required to receive the Session ID of the CA Clarity PPM user accessing the Xcelsius visualization in CA Clarity PPM. This named Flash variable is mapped to the interactive port as the BusinessObjects Session ID global parameter.

        Required Name: CELogonToken

      • (Optional) Web Service URL. Define if you want to use the same Xcelsius visualization as is on multiple CA Clarity PPM servers. This named Flash variable is mapped to the interactive portlet as the BusinessObjects Web Service URL global parameter.
      • (Optional) Other CA Clarity PPM information, such as user name, user internal ID, or language. These named Flash variables are mapped to the interactive portlet as the Clarity User Name, Clarity User Internal ID, or Language global parameters, respectively.
      • (Optional) CA Clarity PPM object-related information to change the behavior based on where the interactive portlet is located in CA Clarity PPM. These named Flash variables are mapped to the interactive portlet as the object parameters that you create.
   4. Link components to the embedded spreadsheet.

More Information:

Query as a Web Service (QaaWS)