SAP Knowledge Base Article - Public

1460390 - Error: "Unsupported Excel Function: PERCENTILE" in Xcelsius 2008

Symptom

  • According to the user guide for Xcelsius SP3, Percentile function of Excel should be supported in Xcelsius 2008.
  • An error: 'Unsupported Excel Function: PERCENTILE' pops up while you preview Xcelsius dashboard using Percentile function.
  • If you click on OK, data using Percentile function is ignored and not displayed in the component after preview.

Environment

  • Xcelsius 2008 SP3

Reproducing the Issue

  1. Create a simple Excel sheet using Percentile function.
  2. In Xcelsius 2008 create a simple dashboard using spreadsheet table to display data.
  3. When you click on preview an error occurs "Unsupported Excel Function: PERCENTILE".

Cause

This is a documentation error. Percentile function is not supported in Xcelsius.

The following problem report has been created and escalated in order to get the documentation corrected : Bug # ADAPT01409666

Resolution

Document to be updated and corrected for the next version of our product

See Also

TE: 5000216249

Keywords

Xcelsius, Percentile, supported, unsupported, preview, 01409666, 1409666 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Xcelsius Enterprise 2008

Attachments

User Guide.zip