Business Objects Xcelsius Implementation

Xcelsius is a dashboard tool that is used to build visualizations that provide a visually rich and interactive approach to analyzing data. You can export a visualization to the Flash file format and create an interactive portlet in . Xcelsius visualizations can display real-time  data outside of , such as from a PowerPoint presentation, Word document, and more.
ccppmod143
Xcelsius is a dashboard tool that is used to build visualizations that provide a visually rich and interactive approach to analyzing data. You can export a visualization to the Flash file format and create an interactive portlet in
Clarity Project and Portfolio Management (PPM)
. Xcelsius visualizations can display real-time 
Clarity Project and Portfolio Management (PPM)
data outside of
Clarity Project and Portfolio Management (PPM)
, such as from a PowerPoint presentation, Word document, and more.
Xcelsius is available only for existing customers who already have this software. This software is not available to new 
Clarity Project and Portfolio Management (PPM)
customers who are installing for the first time.
To get optimal performance from your Xcelsius visualizations, follow the guidelines that are available in the
BusinessObjects Xcelsius 2008 User Guide
, that is provided by SAP. For example, set up complex calculations in the database queries.
The
Clarity Project and Portfolio Management (PPM)
-Xcelsius integration supports the following functionality:
  • Real-time 
    Clarity Project and Portfolio Management (PPM)
    data transfers using 
    Clarity Project and Portfolio Management (PPM)
    Web Services or Business Objects Query as a Web Service as the connection method.
  • Secured data transfers that authenticate 
    Clarity Project and Portfolio Management (PPM)
    users through session IDs and that preserve 
    Clarity Project and Portfolio Management (PPM)
    access rights. Users only see the information that they have rights to view.
  • Context-aware Xcelsius visualizations automatically filter data that is based on where the interactive portlet is located in
    Clarity Project and Portfolio Management (PPM)
    . Here are some examples:
    • Overview page displays unfiltered data, such as all the projects.
    • Project page displays filtered data, such as projects managed by a particular user.
  • Color scheme consistency between the Xcelsius visualization and
    Clarity Project and Portfolio Management (PPM)
    .
  • Multiple language support enables users to view information using their preferred language.
In addition to Xcelsius, the following items are the primary components that are used to implement Xcelsius visualizations with real-time 
Clarity Project and Portfolio Management (PPM)
data:
  • Interactive Portlets
  • Connection Methods for Real-Time Data Exchanges
  • Interactive Portlets Using Global and Object Parameters
Connection Methods for Real-Time Data Exchanges
To enable real-time data exchanges between Xcelsius and
Clarity Project and Portfolio Management (PPM)
, set up the data connection using one of the following connection methods:
  • CA Clarity PPM Web Service. Get real-time 
    Clarity Project and Portfolio Management (PPM)
    data through the 
    Clarity Project and Portfolio Management (PPM)
    Web Service.
  • Query as a Web Service (QaaWS). Get real-time 
    Clarity Project and Portfolio Management (PPM)
    data through the Business Objects Query as a Web Service.
These connections include the data sources that establish real-time data exchanges with
Clarity Project and Portfolio Management (PPM)
. You set up and configure the data connections for your visualizations using the Xcelsius Data Manager. For more information, see the 
BusinessObjects Xcelsius 2008 User Guide
 that is provided by SAP.
Clarity Project and Portfolio Management (PPM)
 Web Service
The 
Clarity Project and Portfolio Management (PPM)
Web Service connection method enables a visualization to get real-time data. This connection method is a good choice in the following situations:
  • Your 
    Clarity Project and Portfolio Management (PPM)
    implementation is integrated with a solution other than Business Objects.
  • You want to use 
    Clarity Project and Portfolio Management (PPM)
    to establish the data source. Experience with writing NSQL is required.
  • You are not able to use the Query as a Web Service connection method.
Secured data transfers are established in the following ways:
  • Authorization
    . A secured session for the logged in 
    Clarity Project and Portfolio Management (PPM)
    user is enabled by creating a Flash variable, such as session_ID, in the Xcelsius visualization. A corresponding session ID is defined in the 
    Clarity Session ID in SOAP Header
     global parameter in the interactive portlet. The Flash Variable Name field of the global parameter must reference the exact Flash variable name in the Xcelsius visualization.
  • Access control
    . User access rights are preserved by including an NSQL security clause to verify that users see only the data to which they have access.
Xcelsius visualization design files (.XLF) are available to get you started quickly using the 
Clarity Project and Portfolio Management (PPM)
Web Service connection method. To review these samples, download 
Design Files for Stock Xcelsius Visualizations
 from the 
Clarity Project and Portfolio Management (PPM)
Software Downloads page.
Query as a Web Service (QaaWS)
The Query as a Web Service (QaaWS) connection method enables the Xcelsius visualization. QaaWS provides real-time 
Clarity Project and Portfolio Management (PPM)
data through the web services that are provided by Business Objects. This connection method is a good choice in the following situations:
  • You want to get the real-time 
    Clarity Project and Portfolio Management (PPM)
    data through your Business Objects web services.
  • You prefer to use 
    Clarity Project and Portfolio Management (PPM)
    Business Object Universes to establish the data source. Experience writing NSQL is not required.
To use this connection method, you must have access to the Business Objects Query as a Web Service tool. If you are licensed to use 
Clarity Project and Portfolio Management (PPM)
through a service provider, contact your service provider to discuss your connection method options.
Secured data transfers are established in the following ways:
  • Authorization
    . A secured session is established for the logged in 
    Clarity Project and Portfolio Management (PPM)
    user by making the Business Objects Session ID available to the Xcelsius visualization. To establish the session, a flash variable, 
    CELogonToken,
     is created in the Xcelsius visualization and mapped to any cell in an Excel sheet. The interactive portlet uses the Business Objects Session ID global parameter.
  • Access control
    . User access rights are preserved through Business Objects universes. The stock 
    Clarity Project and Portfolio Management (PPM)
    Business Objects universes are configured so that users see data based on access rights.