1378689 - Combo Box is caching the previous selection in dashboards based Live Office or QAAWS

SAP Knowledge Base Article - Public

1378689 - Combo Box is caching the previous selection in dashboards based Live Office or QAAWS

Symptom

Combo Box caches the data for the previous selection and does not select the first label by default.

Environment

  • Xcelsius 2008.
  • Dashboards Design 4.0 & 4.1.

Reproducing the Issue

  1. Create a dashboard based on Live office/QAAWS with 3 query. Add combo box for each query.
  2. Query1 should pull in set of data and set it to ‘refresh on load’. (e.g. Country).
  3. Query2 to bring in data based on selection made in the first query. (e.g. State based on country selected).
  4. Set Query2 to ‘refresh on trigger on cell’, where the combo box (‘Country’) Insert is defined.
  5. Set Query3 to bring in data based on selection made in the Query2. (e.g. City based on sate selected).
  6. Set to refresh on trigger cell where the destination of 2nd combo box is defined (e.g. State).
  7. Preview the swf. Make changes in combo box.
  8. Select label 2 in Combo box 1, then select label 3 in combo box2. 
  9. Now select label 1 in Combo box 1, Combo box 2, still selects label 3.

    Cause

    This is the expected behavior of combo box.

    Resolution

    We can use "Reset Button" as workaround.

    Note: This will reset the complete SWF.

    Keywords

    Combo Box, Xcelsius, Dashboards, Selectors, Live office, QAAWS,selectors, components caching. , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

    Product

    SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Xcelsius Enterprise 2008