1492475 - How to trigger QaaWS query that gets prompt inputs from another QaaWS query while both the queries should load with the Dashboard?

SAP Knowledge Base Article - Public

1492475 - How to trigger QaaWS query that gets prompt inputs from another QaaWS query while both the queries should load with the Dashboard?

Symptom

How to trigger QaaWS query that gets prompt inputs from another QaaWS query while both the queries should load with the Dashboard?

Environment

Xcelsius 2008 Enterprise Service Pack 3

Resolution

During Xcelsius Dashboard load, one QaaWS query will not take input filter values from the results of other QaaWS query if both queries are set to 'Referesh on Load'. Try the following steps in order to achieve the desired behavior:

  1. Add first QaaWS query and set it to "Refresh Before Components Are Loaded".
  2. Add second QaaWS query which gets its input prompt values from results of first QaaWS query. Do not set this connection to Refresh.
  3. Add Connection Refresh component and map/check-mark only the second QaaWS query to it. Set this to "Refresh After Components Are Loaded".
  4. Expected functionality should now be achieved.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008