Symptom
Dynamic visibility for certain components does not work anymore.
Environment
- Xcelsius 2008 SP3 and related Fix Packs
- Xcelsius 2008 SP4 and related Fix Packs
Reproducing the Issue
- Create a new dashboard in Xcelsius 2008 SP2
- In the spreadsheet, insert data as follows:
A B C 1 Table =IF(C2=1;(B1&B2);0) 2 Key =IF(B1=A2;1;0) - Insert the following components: Map, Spreadsheet Table, Scorecard, and two Toggle Buttons (Toggle Button 1 and Toggle Button 2)
- Edit Toggle Button 1's properties and set the data as follows: Labels - A1:A2; Source Data - A1:A2; Destination - B1
- Set the Scorecard's Dynamic Visibility as follows: Status - B1; Key - A1
- Set the Spreadsheet's Dynamic Visibility as follows: Status - B1; Key - A2
- Edit Toggle Button 2's properties and set the data as follows: Labels - Off/ 1 and On/ 1; Destination - C2
- Set Toggle Button 2's Dynamic Visibility as follows: Status - D1; Key - 1 (meaning that, D1 being blank, the component will never be shown)
- Set the Map's Dynamic Visibility as follows: Status - C1; Key - Map1 (i.e. B1&B2 when Toggle Button 2 inserts the default "Off" label, 1, into C2)
- Preview the dashboard
- Click on Toggle Button 1 - the map is shown correctly
- Exit the preview and save the dashboard
- Open the .XLF file with Xcelsius SP4
- Preview the dashboard
- Click on Toggle Button 1 - the map is not displayed.
Cause
This is caused by a change in how components hidden by Dynamic Visibility work.
In SP2, even if a component is hidden by Dynamic Visibility, it will still be fully created and will function as if it is not hidden. This mean that Toggle Button 2 will write value to cell C2 even if it's hidden by Dynamic Visibility. This is not true in SP3 (and later versions). In SP3 (and later versions), components won’t write any value to cell C2 if they are hidden by Dynamic Visibility.
Resolution
Make sure that the control cell (in this case, C2), displays the correct value independently from the dynamically hidden component.
Keywords
Crystal, visibilidad, visibilità, dinamica, dynamique, visibilité , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem