SAP Knowledge Base Article - Public

1710501 - Spreadsheet component is not showing 0

Symptom

For the same input value from combo box, spreadsheet table component shows 0.00% initially. When you change input then change it back to initial value again, spreadsheet component shows blank value.

Environment

Xcelsius 2008 SP4

Reproducing the Issue

1) Please find the database entry in excel (Test_DB.xlsx)
2) Create a universe and qaaws in top for it.
3) Make CITY_ID as a prompt in qaaws.
4) Get the data in (Sheet1!$B$4:$G$14) from qaaws
5) Before attaching this data to spreadsheet use below functions

=OFFSET(A3,MATCH($J$4,$B$4:$B$14,0),0)
=IF(ISNUMBER($M$4),ROUND(INDEX(B$4:B$14,$M$4),4),"")

6) preview the model and observe the behavior.

 Same as attached (Test.xlf)

1) Preview the data, and check for column four, first time 0.00% percent shown for 10 selected in combo box
2) Change the column data from 10 to 11 some value appears in fourth column.
3) Go back to 10 with combo box and fourth column is blank now.

Resolution

Go to menu File->Document Properties. On the dialog, uncheck option "Treat Zero as Blank Cell"

See Also

ADAPT01632222

Keywords

0.00%, Blank Value , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008

Attachments

XLF.rar