1625416 - How to create a Crosstab in Xcelsius.

SAP Knowledge Base Article - Public

1625416 - How to create a Crosstab in Xcelsius.

Symptom

How to create a Crosstab in Xcelsius.

Environment

  • Xcelsius 2008
  • Dashboard Design 4.0

Resolution

There is no direct functionality or component in Xcelsius to create a Crosstab. We can create a Crosstab in Crystal Report or Webi Report and then create a dashboard based off it via Live Office.

Please refer following steps:

    1. Create a Crosstab in Crystal Report or Webi Report.

    2. Launch Microsoft Excel, go to Live Office tab, import Crystal/Webi Report created in the above step and save the Live Office document.

    3. Launch Xcelsius, go to Data->Import menu and import the Live Office document created in the above step.

    4. Now take Spreadsheet Table or Scorecard or Grid component on canvas and map it with the Crosstab in the Excel spreadsheet.

    5. Preview the dashboard and notice that the data is displayed in a Crosstab format.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008