1944332 - Query prompt binding is over-written when 2 different Parameters created using @Prompts Selector in UNX are bind to same Excel cell

SAP Knowledge Base Article - Public

1944332 - Query prompt binding is over-written when 2 different Parameters created using @Prompts Selector in UNX are bind to same Excel cell

Symptom

When binding 2 same prompts from 2 different queries based off same UNX, the binding is getting over-written and both the prompts are bind to the same cell.

Environment

  • Dashboard 4.0 SP05
  • Dashboard 4.1

Reproducing the Issue

  1. Create a UNX off any database and create Parameter within Business Layer using @Prompt Selector.
  2. Create a query within Dashboard Designer using Query Browser.
  3. Bind the prompts to a cell within Excel, say A1
  4. Create another query off same UNX and bind the prompts to another cell, say A2.
  5. Save and close the Dashboard.
  6. Open the dashboard again and check the binding of the Prompts for both the queries. They are bind to cell A2.

Cause

The issue has been identified and logged under Problem Report ID ADAPT01703945

Resolution

This issue has been addressed in SP07 Patch 2 and BI4.1 SP01 Patch 1.

To fix the existing Dashboards:

  1. Upgrade Dashboard client to Patch7.2 or higher.
  2. Open existing dashboard, delete all DSL which contains @prompt
  3. Re-create these DSL connections

Keywords

ADAPT01702727, Prompt binding, overwritten , KBA , BI-RA-XL-DSL , Dashboards, design-time, design on multi-source , Bug Filed

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1