1 / 36

Xcelsius Tips and Tricks

Xcelsius Tips and Tricks. Chris Greer EV Technologies. Who We Are…. EV Technologies is an SAP BusinessObjects solutions firm based in the St. Louis Metro Area SAP Software Solutions Partner SAP Certified Solutions Provider. Agenda. Creating BIWS with the Rich Client

weldon
Download Presentation

Xcelsius Tips and Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Xcelsius Tips and Tricks Chris Greer EV Technologies

  2. Who We Are… EV Technologies is an SAP BusinessObjects solutions firm based in the St. Louis Metro Area • SAP Software Solutions Partner • SAP Certified Solutions Provider

  3. Agenda • Creating BIWS with the Rich Client • Monitoring Connections using the built in Load Status • Xcelsius in XLF documentation

  4. BIWS in Rich Client • Publish a BIWS from a report block in the Rich Client • Filters • Prompts • Testing a BIWS in the Rich Client • Create a connection to a BIWS in Xcelsius • Map the connection to run against the latest Instance of a webi report.

  5. Rich Client Demo • Rich Client Demo • Creating a BIWS • Testing the BIWS

  6. Getting Started • Create your Web Intelligence Report • Keep it simple Remember a BIWS is tied to a block not the whole report

  7. Setting the Block Name • The Block Name is Important

  8. Always Export First • We select the Block and then Publish it • If you have not exported the rich client report to the CMS you will get an Error

  9. BIWS Wizard • Once we have exported the report we can try again

  10. Name the Service • Set the filters • Notice the name matches our block name

  11. Set Filters • Document the BIWS name and filters in the report

  12. BIWS Folders • Recommendation: Create a folder for each Dashboard • Note that BIWS co-exist with QaaWS services

  13. Publish the BIWS • Name the BIWS and Finish

  14. Testing a BIWS • You can not Modify or test Rich Client BIWS through the QaaWS client tool • The Rich Client provides an Interface for testing BIWS created with the rich Client

  15. Testing a BIWS • Checking the “Show BI Service” box • WSDL URL contains the URL you need for your Xcelsius connection • Identifier contains the CUID for the BIWS

  16. Test it

  17. Invoke the Test • Here we can populate values for the filters • If you leave a filter blank it is not used • Once you are ready, click Send

  18. Test Results • Review the results

  19. Xcelsius Demo • Xcelsius Demo • BIWS Connections

  20. Connecting to the BIWS • Import the URL we got from the Rich Client

  21. Methods • Change to the Get method instead of the Drill Method

  22. Understanding New Inputs • BIWS and tradition QaaWS have different options • We set the value to 1 for TRUE • Refer to the Web Intelligence manual for all the details

  23. Schedule to Cache • Since we are running against latest instance we need to schedule the report in InfoView

  24. Handling Input Parameters • Set the Filters Values • Filters apply to the data in the report instance • Prompts force a webi report refresh

  25. Test BIWS in Xcelsius • Now we can run it

  26. Drill Down Test • Change the value to validate it works

  27. BIWS Summary • Create a BIWS against a crosstab, which could previously only be done with Live Office • Cache data and avoid making a database call • Instances and Filters help us work around 500 row limits • Can see 2-3 second response time running against a 40+ MB Webi instance

  28. Connection Load Status • Set the Connection Load Status Properties • Loading Message • Idle Message • Insert In • Monitor a running query

  29. Load Status Bind Variables • Loading Message • Idle Message • Insert Into

  30. Create the Output Object • Created a scorecard to show where we mapped the Insert Into property

  31. Monitoring Running Queries • Here we see the loading and Idle messages

  32. Load Status Summary • Learn to leverage Xcelsius internal connection watching • Debug when connections are triggered • Connection performance tuning • There are external tools like Fiddler that let you watch externally (another presentation)

  33. Xcelsius Demo • Xcelsius Demo • Web Service URL

  34. Xcelsius Documentation • Label in Webi with BIWS name • Include Prompts • Include Filters • Connection name is the BIWS name • Give all Components Names • Color Code Cells • Put a legend on every sheet • Comment the destinations of Connections and Selectors

  35. Xcelsius Demo • Xcelsius Demo • Coding Standards

  36. More Information Contact: Chris Greer Email: chris@evtechnologies.com Office: 314.514.4082 On the Web: http://savethecms.com Blog: http://evtechnologies.com/blog Twitter: @mrchrisgreer

More Related