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 , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem