1607764 - Unable to change prompt value in Query Browser if prompt is defined in Information Design Tool (IDT) on Dashboard Design / Xcelsius

SAP Knowledge Base Article - Public

1607764 - Unable to change prompt value in Query Browser if prompt is defined in Information Design Tool (IDT) on Dashboard Design / Xcelsius

Symptom

  • Unable to change the prompt value
  • The prompt section is grayed out

Environment

  • Dashboard Design BI4.0 SP02

Reproducing the Issue

  1. Launch IDT
  2. Open the Island resorts.unx
  3. Open the .DFX file
  4. Edit the link between ‘Customer’ and ‘Age group’
  5. In the link SQL expression, replace with the following SQL:
  6. Customer.age=@prompt('enter age','N',,MONO,FREE,,)
  7. Validate the SQL and close the window
  8. Save the changes
  9. Select the .BLX and publish the universe to the repository
  10. Launch Dashboard Design
  11. In the query browser, create a new query
  12. Select the Island universe and choose objects ‘customer’ and ‘revenue'
  13. The prompt window is displayed: Enter a value 
  14. Click OK to finish
  15. In the query browser, you notice the ‘prompt’ section is greyed out: You are unable to select another value:

Resolution

  • This issue has been resolved under SP04 Patch 2.

Keywords

grayed out dashboard selection @prompt linking ADAPT01563114 1563114 , KBA , BI-RA-XL , Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Dashboards 4.0