1 / 25

COMP-9: Crystal Xcelsius Brings Fast/Easy Graphics to Data

COMP-9: Crystal Xcelsius Brings Fast/Easy Graphics to Data . Stefan Glover, Business Relationship Manager, OEM, Business Objects Mark Warner, Technical Sales Consultant, OEM, Business Objects Jim Lundy, Principal Product Manager, Progress. Agenda. Steal the Show. Crystal Xcelsius

buffy
Télécharger la présentation

COMP-9: Crystal Xcelsius Brings Fast/Easy Graphics to Data

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. COMP-9: Crystal Xcelsius Brings Fast/Easy Graphics to Data Stefan Glover, Business Relationship Manager, OEM, Business Objects Mark Warner, Technical Sales Consultant, OEM, Business Objects Jim Lundy, Principal Product Manager, Progress

  2. Agenda Steal the Show • Crystal Xcelsius • Crystal Xcelsius Integration • Demonstration COMP-9: Xcelsius Graphics

  3. Visualize and Embed your Data COMP-9: Xcelsius Graphics

  4. Introducing… Crystal Xcelsius Powerful, yet simple, dynamic visualizations • Turn Data into Information • Based on Excel data and formulas • Live XML and Web Service data • Interactive What-If Analysis • Drill-Down, Charts, Gauges, Dials • Export to Office, PDF, and HTML • Flash format – Easy to Embed COMP-9: Xcelsius Graphics

  5. How Crystal Xcelsius Works 2. Create an interactive presentation with point-and-click. 3. Output final interactive analytic or presentation to Dashboard Manager, any web page, PowerPoint, Outlook or PDF – with just one click! 1. • Source data from: • Excel spreadsheets • XML data • SOAP-based Web Services Deliver interactive visual analytics to the business user COMP-9: Xcelsius Graphics

  6. Agenda Steal the Show • Crystal Xcelsius • Crystal Xcelsius Integration • Demonstration COMP-9: Xcelsius Graphics

  7. Crystal Xcelsius Connectivity Options • SOAP-based Web Service • state-of-the-art data integration • easy-to-use implementation • Custom Middle-Tier • feed visualization with data from a live XML stream • robust solution for real-time visualization integration with any database or application • Excel with Automated Refresh • automated update of visualization • Flash Variables • Push information into the visualization using external web scripts like .jsp and .aspx pages COMP-9: Xcelsius Graphics

  8. Option 1 - Export Data From Crystal Report COMP-9: Xcelsius Graphics

  9. Option 2 - Custom Middle TierUse a jsp page or aspx page to get data COMP-9: Xcelsius Graphics

  10. Option 2 – Sample Code (.aspx example) balanceamt = Request.QueryString("maxbalanceamt") if balanceamt = "" then balanceamt = 40000 end if sSQL = "SELECT Customer.Name, Customer.Balance FROM PUB.Customer Customer where Customer.Balance > " & balanceamt & " order by Customer.Balance DESC" 'Create connection object sConnect = "DSN=sports2005;DATABASE=" & DbName & ";UID=" & uid & ";PWD=" & pWd & ";" oCon = Server.CreateObject("ADODB.Connection") oCon.ConnectionString = sConnect oCon.Open dim oRst as Object oRst = Server.CreateObject("ADODB.RecordSet") oRst.ActiveConnection = oCon oRst.Open(sSql) COMP-9: Xcelsius Graphics

  11. Sample Code (.aspx example) Cont…. Response.Cache.SetExpires(DateTime.Now) Response.Write("<?xml version='1.0'?>") 'Build XML data to return dim sXML as String sXML = "<data>" sXML = sXML & "<variable name=" + chr(34) + "Range0" + chr(34) + ">" Do Until oRst.EOF 'totalData sXML = sXML & "<row>" sXML = sXML & “<column>” & REPLACE( oRst(“Name”).value, “&”, “&amp;” ) & “</column>” sXML = sXML & "<column>" & oRst("Balance").value & "</column>" sXML = sXML & "</row>" oRst.MoveNext Loop sXML = sXML & "</variable></data>" Response.Write(sXMl) COMP-9: Xcelsius Graphics

  12. Option 2 - Sample Format of XML <?xml version='1.0'?> <data><variable name="Range0"> <row> <column>Hook, Line &amp; Sinker</column> <column>55933.78</column> </row> <row> <column>Apple River Sports</column> <column>45174.65</column> </row> <row> <column>Nash's Sports &amp; Casuals</column> <column>43983.51</column> </row> <row> <column>Don's Bait &amp; Tackle</column> <column>42437.01</column> </row> </data> COMP-9: Xcelsius Graphics

  13. Build Xcelsius Model COMP-9: Xcelsius Graphics

  14. Option 3 – Web Service • http://internal.infommersion.com/services/quotes/xquotesproxy.asmx?wsdl COMP-9: Xcelsius Graphics

  15. Option 3 - Sample Model using a web service COMP-9: Xcelsius Graphics

  16. Option 4 – Flash Variables <HTML> <HEAD> <TITLE>flashvar.swf</TITLE> </HEAD> <BODY> <OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" WIDTH="973" HEIGHT="597" id="myMovieName"> <PARAM NAME=FlashVars VALUE="Range0=GA%2C120583.330000%2C4.000000%2C236288.863096%2CPA%2C216941.670000%2C5.000000%2C234622.416105%2CME%2C211254.520000%2C7.000000%2C232823.606492%2CNV%2C208435.210000%2C9.000000%2C234010.210267%2CMS%2C203319.410000%2C1.000000%2C211513.182223"> <PARAM NAME=movie VALUE="flashvar.swf"> <PARAM NAME=quality VALUE=high> <PARAM NAME=bgcolor VALUE=#FFFFFF> <EMBED src="flashvar.swf" quality=high bgcolor=#FFFFFF WIDTH="973" HEIGHT="597" FlashVars="Range0=GA%2C120583.330000%2C4.000000%2C236288.863096%2CPA%2C216941.670000%2C5.000000%2C234622.416105%2CME%2C211254.520000%2C7.000000%2C232823.606492%2CNV%2C208435.210000%2C9.000000%2C234010.210267%2CMS%2C203319.410000%2C1.000000%2C211513.182223" NAME="myMovieName" ALIGN="" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer"> </EMBED> </OBJECT> </BODY> </HTML> COMP-9: Xcelsius Graphics

  17. Xcelsius Integration: Behind the Scenes Publish Visualization to the your Progress-based application 4 Connect to corporate data sources via Web Service, XML, etc. 1 Data is populated into Excel model Import Excel model into Crystal Xcelsius and generate Visualization 2 3 Development stages of a Crystal Xcelsius model Business Visualization Data Connectivity Excel Model Data Source Tier Business Logic Tier Visualization Tier Web/Client Tier COMP-9: Xcelsius Graphics

  18. Xcelsius Integration: Time to Deliver Corporate Database Deployment of a Crystal Xcelsius model Client Side Web Tier Data Tier COMP-9: Xcelsius Graphics

  19. Embed into existing Applications COMP-9: Xcelsius Graphics

  20. Agenda Steal the Show • Crystal Xcelsius • Crystal Xcelsius Integration • Demonstration COMP-9: Xcelsius Graphics

  21. Demo Workflow • Connect to Progress database via a Custom Middle-Tier (XML) • Creating Excel model from the Progress database • Designing Visualizations based on Progress Excel models • Saving and Publishing Xcelsius model to an existing application COMP-9: Xcelsius Graphics

  22. Demonstration COMP-9: Xcelsius Graphics

  23. Questions? COMP-9: Xcelsius Graphics

  24. Thank you foryour time COMP-9: Xcelsius Graphics

  25. COMP-9: Xcelsius Graphics

More Related