1705952 - Dynamic visibility of Calendar picker with prompt doesn't allow to pick a value without refreshing the data after the calendar is opened the second time.

SAP Knowledge Base Article - Public

1705952 - Dynamic visibility of Calendar picker with prompt doesn't allow to pick a value without refreshing the data after the calendar is opened the second time.

Symptom

  • Dynamic visibility of Calendar picker with prompt doesn't allow to pick a value without refreshing the data after the calendar is opened the second time.
  • Calendar Picker freezes
  • Calendar picker using Dynamic visibility hang

Environment

  • Dashboard Design BI 4.0.2 Patch 14
  • Live Office BI 4.0.2 Patch 14

Reproducing the Issue

  1. Create a Web Intelligence Report based on Island Resort and Marketing
  2. Select object Reservation Year, Reservation Quarter and Reservation Month
  3. Add a filter on Reservation Date between prompt
  4. Run the Query
  5. Select start date as 01/01/2007
  6. Select End date as 17/02/2007
  7. Click Ok
  8. Save the report as calendar
  9. Create a Dashboard in BI 4.0 using 'Live Office' >'Interactive Analysis' feature
  10. Import the report part from named 'Calendar'.
  11. Goto Objects Properties
  12. Under Book 1 un-tick the box for "Consolidate Prompts for Each document type"
  13. Click on the report name
  14. On the 'Prompts' tab Click on 'Prompt Values'
  15. Bind Start date to Cell E2 and End Date to cell F2
  16. Goto 'Data' > 'Connections..'
  17. Select 'Add' > 'Live Office Connections'
  18. Under Usage tick the boxes for 'Enable Load Cursor' and 'Disable Mouse Input on Load'
  19. Add the following components:
    1. History
      • Source bound to E2 and Destination to E6
    2. Spreadsheet table
      • 'Display Data' Bound to A1 to F14
    3. Push Button
      • 'Source Data' bound to E4 'Destination Data' to E6
      • Cell 'E4' contains the value 'Y'
    4. Calendar
      • Set as Date
      • Destination bound to 'E2'
      • Under 'Behaviour' for 'Dynamic Visibility' set with Status bound to cell E6 and Key to 'E4'
    5. Connection Refresh Button
      • Select 'Calendar Document Part'
      • Under 'Behaviour' 
        • Select Trigger Cell 'E2'
        • When Value Changes
    6. Set the value for E2 01/01/2007 and for F2 to 17/02/2007
  20. Preview the dashboard 
  21. Click on the Push Button
  22. Select a date
  23. The query refresh
  24. Click on the Push Button again
  25. The calendar shows but it is impossible to select a date.

Cause

This is a product Defect there is no ADAPT associated with this defect

Resolution

Current Workaround is to refresh manually the dashboard connection using a Connection Refresh Button.

If Automatic refresh is required, bind the Cell for the refresh on change to the Cell E6 in our example which is the one defining the dynamic visibility of the Calendar.

Resolution:

Install Dashboard Design Feature Pack 3 or SP04.

 

Keywords

5050059581, calendar, picker, dynamic, visibility, hang, freeze, select unable, disable , KBA , BI-BIP-LO , Live Office , Problem

Product

SAP BusinessObjects Dashboards 4.0