SAP Knowledge Base Article - Preview

1207028 - Data disappears on preview in Xcelsius when using array formulas in Excel

Symptom

You have a formula containing variables referencing a cell range in Excel.

If you create a model using an Excel data source which contains formulas such as the following:

=IF (COUNTRY<>"", Revenue*5)

where COUNTRY and Revenue are variables with data range values.

While previewing the model in .xlf, the chart/graph content will disappear.

If you display the data in a table, then "NaN" (Not a Number) will be displayed.


Read more...

Environment

  • BusinessObjects Xcelsius 2008
  • BusinessObjects Dashboard

Product

SAP BusinessObjects Dashboards 4.5

Keywords

data disappears using array formulas , 9726470 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.