Skip to Content
Author's profile photo Jamie Wiseman

Greater Speed & Flexibility for Xcelsius Dashboard Components

If you are building a dashboard that contains Xcelsius components, you can use Crystal Reports as a container for the component for greater speed and flexibility. Using the Crystal Reports Report Part viewer, you will have a seamless component in your dashboard.

 

Advantages to using this method:

  1. ODBC or OLE or Data Direct connections will outperform a web service
  2. Embedded Xcelsius components use BusinessObjects Crystal Reports servers for better performance and management
  3. Auditing can now be done against the embedded Xcelsius component
  4. Take advantage of Crystal Reports powerful formula editor
  5. Take advantage of other features in Crystal Reports 2008 such as Saved Data, dynamic grouping, localization / translation methods (UFL’s or Custom Functions) etc.

 

 

 

To use this technique, you must have:

  1. BusinessObjects Enterprise 3.x or Crystal Reports Server 2008
  2. Crystal Reports 2008
  3. Xcelsius 2008 

 

Steps:

 

1) First you have to use the Crystal Report Data Consumer in Xcelsius. There are instructions on doing this here. By using the Data Consumer, you can later map the variables in Crystal Reports.

 

2) Create a new Crystal Report off of your desired data source using an ODBC or OLE or Data Direct connection. Using these connections you can dramatically increase the speed of the data connection for the Xcelsius component versus using Live Office or a web service.

 

3) Insert the Xcelsius model and use the Data Expert in Crystal Reports to map the flash variables as per the instructions in the step 1 document.

 

4) Right click on the embedded Xcelsius model and choose Format Flash, then go to the Common tab and copy the Object Name.

 

5) Go to the File menu, then Report Options, and copy this Object Name into the Initial Report Part Settings. Do not put anything in the Data Context box. Save this report to your BusinessObjects Enterprise system.

 

6) Go to BusinessObjects Infoview and go to the dashboard you are building. Press the Edit Dashboard button and go to the Corporate Analytics, find your new report, and drag your report onto your dashboard.

 

7) Press the Edit button and select Parts Viewer and use the Default Report Part. Make sure that On Demand is selected.

 

You now have an Xcelsius dashboard component that is utilizing the Crystal Reports data connection and servers.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      We are not using BO Dashboard builder to show the dashboards.  Can we make any specific API calls that will retrive only part of the CR as done in Dashboard builder?
      Author's profile photo Jamie Wiseman
      Jamie Wiseman
      Blog Post Author
      you can use the opendocument functionality of businessobjects enterprise / crystal reports server to call a report and therefore avoid using infoview or dashboard builder.

      if you've got a web portal or app you bring in part of a report or the entire report using opendocument. see the Opendocument / Crystal Reports URL reporting in the sdk site here http://www.sdn.sap.com/irj/boc/sdklibrary

      you will want to use the Report Part opendocument parameters to call a single part of a report. there is also more information on Report Part linking in your crystal reports online help. this is a very useful feature in crystal reports that unfortunately is not well known.

      also, you may wish to see the blog below for several more opendocument parameters to make the viewer look better in your portal or web app.
      Hiding the Toolbar in Crystal Reports and 2 Other Great OpenDocument Features