How to trigger QaaWS query that gets prompt inputs from another QaaWS query while both the queries should load with the Dashboard?
Xcelsius 2008 Enterprise Service Pack 3
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:
- Add first QaaWS query and set it to "Refresh Before Components Are Loaded".
- Add second QaaWS query which gets its input prompt values from results of first QaaWS query. Do not set this connection to Refresh.
- Add Connection Refresh component and map/check-mark only the second QaaWS query to it. Set this to "Refresh After Components Are Loaded".
- Expected functionality should now be achieved.
KBA , BI-RA-XL , Dashboards and Presentation Design , How To