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 • Crystal Xcelsius Integration • Demonstration COMP-9: Xcelsius Graphics

Visualize and Embed your Data COMP-9: Xcelsius Graphics

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

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

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

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

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

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

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, “&”, “&” ) & “</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

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

Build Xcelsius Model COMP-9: Xcelsius Graphics

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

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

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

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

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

Embed into existing Applications COMP-9: Xcelsius Graphics

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

Demonstration COMP-9: Xcelsius Graphics

Questions? COMP-9: Xcelsius Graphics

Thank you foryour time COMP-9: Xcelsius Graphics

COMP-9: Xcelsius Graphics

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