Skip to Content
Author's profile photo Vinaykumar Mhaske

How to create Xcelsius Dashboard based of BI Web Service ( BIWS )

1. Launch Webi Rich Client, select Universe as a document source and click on Next.

       1) Select Document Source1.jpg

2. Select the desired universe from the list of available universes and click on OK.

    2) Select universe from BOE1.jpg


3. Drag State to Result Objects pane.

    3) Select State1.jpg

4. Click on Run Query.

    4) Click Run Query2.jpg

5. The data is shown. Notice that the Webi block is created with one column.

    5) Result of Run Query.JPG

6. Now export the Web Intelligence Report to CMS.

    6) Export report to BOE11.jpg

    7) Export report to BOE11.JPG

7. Now right click on the block and select Publish Block.

    8) Publish Block1.jpg

8. Click on Next.

    9) Publish Block11.jpg

9. Enter name and click on Next.

    10) Publish Block2.JPG

10. Highlight Web Services on BOE31 and click on Create.

    11) Create BIWS1.jpg

11. Enter Web service name and click on OK.

    12) Create BIWS1.JPG

12. Test1 web service is created successfully.

    13) Creating BIWS msg1.jpg

    14) BIWS successfully created msg1.jpg

13. Click on Finish.

    15) Finish1.jpg

14. Now select Show BI Services from the right top corner.

    16) Show BI Services1.jpg

15. Notice that the Web Service Publisher window appears.

    17) Show BI Services1 1.jpg

      Note: WSDL URL is the url of the web service ‘Test1’ that we just created.

16. Now launch Query As A Web Service tool. Notice that Test1 BIWS is listed under QaaWS. Select Test1 and click on To Clipboard.

    18) QaaWS To Clipboard1.jpg

17. Launch Xcelsius designer, go to Data Manager and add new Query As A Web Service Connection.  Paste the copied query in front of WSDL URL and click on Import button.

    19) Import query in Xcelsius1.jpg

18. Bind query output with excel spreadsheet.

    20) Map output with excel1.jpg

19. Go to Usage tab and check Refresh Before Components Are Loaded.

    21) Check refresh before option1.jpg

20. Take Spreadsheet table component on canvas and map its Display Data with query output in excel spreadsheet.

    22) Drap spreadsheet table and map with excel.JPG

21. Preview the dashboard.

    23) Preview and see the data.JPG

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Abhilash Kumar
      Abhilash Kumar

      Excellent Document!

      Author's profile photo Ravi Sarma
      Ravi Sarma

      very good document  i got clear picture on webservice

      it very helpfull doc..

      keep posting...

      good luck..

      Author's profile photo Durga Prakash Jasti
      Durga Prakash Jasti

      Nice Document!!

      Good work ...Keep sharing...

      Author's profile photo Former Member
      Former Member

      It is nice effort to give clear steps.