SAP Knowledge Base Article - Public

2205599 - Cannot get the correct snapshot data when previewing in Dashboards designer

Symptom

Cannot get the correct snapshot data when previewing in Dashboards designer

Environment

  • SAP BusinessObjects Dashboards 4.0 / 4.1 / 4.x

Reproducing the Issue

  1. Launch Dashboards designer and create a new dashboards document.
  2. Add a Combo Box and assign some value into it.
  3. In the Excel spreadsheet, for example, set a value to cell C1 and set C2 as a formula =C1
  4. In the properties of the Combo Box, set the Destination of Data Insertion as cell C2.
  5. A warning dialog appears as Insert in Selection should not contain cells that have formulas. Do you wish to continue?
  6. Click Yes to continue.
  7. Add a Label component to link to the cell C2.
  8. Click Preview to preview the dashboards document.
  9. Select some value from the combo box, find the value in Label is changed as C2 is updated.
  10. From menu, click File -> Snapshot -> Current Excel Data, save the snapshot to xls Excel file.
  11. Open the xls file and find C2 is still =C1 which is not the updated value.

Cause

This behavior is BY DESIGN.

All components that have data insertion is not allowed to set the destination to the cells which have formulas.
In this scenario, a warning dialog appears to mention the same thing. It means if this requirement is not met, some unexpected behavior would happen.

Resolution

Change the Destination of Data Insertion of the Combo Box to another cell which has no formula.

Keywords

xcelsius, new, old, flash, swf, function , KBA , BI-RA-XL , BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1