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

Previous Topic: Set up the CA Clarity PPM Web Service Connection to Xcelsius Visualizations

Next Topic: Add a Web Connection Definition

Set up the QaaWS Connection to Xcelsius Visualizations

Use these steps if you are using the Query as a Web Service (QaaWS) to establish real-time data transfers between CA Clarity PPM and the Xcelsius visualization.

Users who view Xcelsius visualizations that transfer data using the Query as a Web Service connection method must be members of the following Business Objects security groups:

See the Administration Guide for more information.

Follow these steps:

  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 the 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 to CA Clarity PPM.

    See the BusinessObjects Xcelsius 2008 User Guide for more information.

    1. Complete the following field:
      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 Business Objects Session ID global parameter.

        Required Name: CELogonToken

      • (Optional) Web Service URL. Optional. 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 Business Objects Web Service URL global parameter.
      • (Optional) Other CA Clarity PPM information, such as user name, user internal ID, or language. The 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)