1996794 - How to create a Dashboard based on the crosstab using web services published from a Webi report.

SAP Knowledge Base Article - Public

1996794 - How to create a Dashboard based on the crosstab using web services published from a Webi report.

Symptom

How to create a Dashboard based on the crosstab using web services published from a Webi report.

Environment

  • SAP BusinessObjects Dashboards 4.1
  • SAP BusinessObjects Dashboards 4.2
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence platform 4.2

Resolution

1. Create a Webi report in Cross tab format.

2. Publish the Cross tab block as a Web service.

3. Launch Dashboard Designer.

4. In the Data -> Connections ->Add -> Web Service Query (Query As A Web Service).

5. Click on import button.

6. In the output values ->Table -> row ->cell, map it to a range.

 

1.png

7. In output values ->Headers -> Row ->Cell

2.png

 8. Map it to the row above the previously mapped range.

3.png

9. In the Usage option ->Check refresh before components are loaded.

10. Drag a Spreadsheet Table component in the Canvas.

11. Map it to the whole range.

5.png

12. Preview the Dashboard.

Keywords

BIWS, Xcelsius, Crosstab table, BI web service, webi , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Dashboards 4.1