1643414 - Bex replacement path variable triggers sub query to run

SAP Knowledge Base Article - Public

1643414 - Bex replacement path variable triggers sub query to run

Symptom

Replacement path variable query runs before dashboard is loaded and not when triggered.

Environment

  • Netweaver Portal
  • Xcelsius 2008 Dashboard
  • BEx query with replacement path variable

Reproducing the Issue

  1. Create a bex query with replacement path variable.
  2. Create a dashboard off that query.
  3. In the dashboard, set a trigger (Refresh button), which sets off the query.
  4. Save the dashboard to the portal.
  5. Launch dashboard.
  6. Before the dashboard comes up, Mandatory Variable prompt comes up or the replacement path variable query starts running.
  7. Enter the value for the Mandatory Variable or the replacement path variable.
  8. The dashboard comes up. It's empty, because the query has not still been executed.
  9. Set the trigger in the dashboard, which sets off the query, which in turn sets off Mandatory variable or replacement path variable query.
  10. Dashboard comes up with correct data.

Cause

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

Resolution

This issue has been rejected by design.  The BEx variable are provided before dashboard is loaded. 

Keywords

xcelsius, dashboard, bex variable, replacement path variable, portal, 01530370 , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008