SAP Knowledge Base Article - Public

1200621 - Does Dashboards Design support Excel pivot tables?

Symptom

Does Dashboards Design support Excel pivot tables?

Environment

  • Xcelsius 2008
  • Dashboards Design 4.0

Resolution

Dashboards Design does not support the pivot table functionality. Dashboards Design allows you to import Microsoft Excel files that have pivot table data and use that data.

For example, you can import an Excel workbook that has pivot tables and use a Table Selector component to visualize the range of cells that is the output of the pivot table. Dashboards Design can then display the output of a pivot table, however it cannot recalculate. Currently, Dashboards Design does not support the function GETPIVOTDATA.

Keywords

Xcelsius, Pivot tables , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008