1706408 - How to pass value to BEx query variable from Xcelsius

SAP Knowledge Base Article - Public

1706408 - How to pass value to BEx query variable from Xcelsius

Symptom

How to pass value to BEx query variable from Xcelsius

Environment

  • SAP BusinessObjects Dashboard 4.0
  • Sap Netweaver 7.0 EHP01

Resolution

Here's the way to implement passing value to BEx query variable from Xcelsius via Query as a Web Service.

  1. Create an BEx query which includes optional variable.(For example, vartest...)
  2. Log on Universe Design Tool. (.unx type universe is not supported in Qaaws, so it's necessary to create .unv type universe)
  3. Create universe [testunv] base on above BEx query. Save and export to repository.
  4. Log on Query as a Web Service and create an web service with above universe [testunv].
  5. Open Xcelsius and create a Web service query (Query as a Web Service) using URL generated on step 4.
  6. Import the URL and bind the variable into excel cell as input value.
  7. Bind the rows to some excel cells as output value.
  8. Then open Usage tab, check Refresh Before Components Are Loaded.
  9. Bind the Trigger Cell to the input value cell on step 6. Close.
  10. Drag a List View to Canvas and bind the Display data to the output value cells on step 7.
  11. Drag an Input text to Canvas and bind Data Insertion to input value cell on step 6.
  12. Preview and input value into Input text box.
    => Corresponding data displayed after inputting different value.

------Screen capture attached for reference-------

Keywords

Qaaws, param, bw, transaction, failed, cannot refresh, trigger, BI, BO, 4.0 , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0

Attachments

screenshot.xlsx