Actuate 9 Technical Overview and Product Update

1. Actuate 9 Technical Overview and Product Update Paul Clenahan VP, Product Management Actuate

2. Product Update: Agenda • Overview • Open Source • Business Intelligence and Reporting • Performance Management

3. iPortal iPortal e.Report e.Spreadsheet BIRT Reports e.Spreadsheet BIRT Reports BusinessReport e.Spreadsheet BIRT Reports BusinessReport Analytics Information Objects iServer Services Report Scheduling & Management Notification & Distribution Clustering & High Availability Security & Application Integration Actuate 9 Product Suite Open Source Commercial Performancesoft Eclipse BIRT Embedded Reporting Engine Workgroup Reporting Enterprise Reporting

4. Recent Releases A Busy 12 Months!

5. iPortal iPortal e.Report e.Spreadsheet BIRT Reports e.Spreadsheet BIRT Reports BusinessReport e.Spreadsheet BIRT Reports BusinessReport Analytics Information Objects iServer Services Report Scheduling & Management Notification & Distribution Clustering & High Availability Security & Application Integration Actuate 9 Product Suite Open Source Commercial Performancesoft Eclipse BIRT Embedded Reporting Engine Workgroup Reporting Enterprise Reporting

6. Open Source Reporting: Eclipse BIRT BIRT = Business Intelligence and Reporting Technology • Open source initiative as part of the Eclipse Foundation • Founded, organized and led by Actuate • Project launched in October, 2004 Over 1 Million Downloads as of June, 2007 Project Highlights • Next generation technology • Eclipse-based Report Designer • Web-centric design metaphor • Open Source with rapid adoption • Standards based • Open XML design format

7. Eclipse BIRT 2.2 Part of Eclipse “Europa” simultaneous release Released on June 27, 2007, simultaneously with 20 other Eclipse projects • Support for a wider range of report types and easier report development • New chart types and more control over charts • New output formats to common office tools • New data sources and improved data access • Easier application integration and extension development Open Source BIRT Report 2.2 New Features

8. Eclipse BIRT 2.2 Crosstabs

9. Eclipse BIRT 2.2 Crosstabs Dynamic Crosstab Support • New Report Item on palette • Drag and drop creation • Multiple level support • Built on cube engine • …many features Quickly and Easily Incorporate Crosstabs in BIRT Reports

10. Eclipse BIRT 2.2 Output Formats New Output Formats • Microsoft Excel • Microsoft Word • Microsoft PowerPoint • PostScript

11. iPortal iPortal e.Report e.Spreadsheet BIRT Reports e.Spreadsheet BIRT Reports BusinessReport e.Spreadsheet BIRT Reports BusinessReport Analytics Information Objects iServer Services Report Scheduling & Management Notification & Distribution Clustering & High Availability Security & Application Integration Actuate 9 Product Suite Open Source Commercial Performancesoft Eclipse BIRT Embedded Reporting Engine Workgroup Reporting Enterprise Reporting

12. Collaborative Reporting Architecture • Skills-specific environments for every user • Open: Eclipse, Java, portlets, XML, AJAX • Design sharing & interactive viewing for everyone Casual Users, Customers & Partners Power Users & Business Users Application Developers, Data Architects & Report Designers Common, BIRT-based design format Report Producers Report Consumers Common Report Design Actuate BIRT BusinessReports Interactive Viewing Printed Output Client/Server web-report development Web-basedad hoc reporting Web-based personalization

13. Actuate BIRT Report Designers Desktop tools for professional IT developers and power users Open Source BIRT plus, one-click installer and data adapters Actuate BIRT Options for iPortal and iServer Ready-to-go deployment servers for BIRT Reports Scheduling, security, email notifications, report management, … Actuate BusinessReport Studio Web tool for BIRT report creation by business users Simple to use yet powerful template based model Actuate BIRT Report Interactive Viewer Web tool for exploring and manipulating report documents Answer ad hoc business questions without writing a report Actuate BIRT Product Line

14. Collaborative Reporting Architecture:Actuate 9 SP2 Updates Responding to Early Adopter Feedback on Actuate 9 BusinessReport Studio • Support for reports with multiple detail lines • Enhanced column header and label control Interactive Viewer • Wider filtering flexibility with compound filters • Easily select and act on multiple columns • More control over chart properties

15. Collaborative Reporting Architecture:Actuate 9 SP2 Updates Better Support for Printed Reports • More control over printed report layout in BusinessReports • Improved generation of PDF output for printing • “Scale to page size” for wide reports

16. e.Reports: Brochure Quality Reporting Conditional formatting Developer Productivity Improvements • Conditional formatting without writing code • Range of IDE enhancements Improved Text Handling, Graphics and Charts for Brochure Quality Reports • Full justification / keep next / keep together / soft hyphenation in dynamic text • Improved custom component creation • New Bubble Chart support Information Objects Integration • New Query Export tool to quickly prototype an Information Object • Information Object Designer now bundled with e.Report Designer Pro

17. e.Reports: Output to PowerPoint Fully editable – Users can add annotations or amend content

18. e.Spreadsheet: Automated Spreadsheet Generation Support for large end-user populations and less technical report developers • SmartSheet Security – “Page level security” but with finer granularity • Each user only sees the report components for which he/she is authorized • Updated, easier to learn and more powerful user interface • Listing Wizard: Enables users to quickly create simple listing reports • New Report Functions for easier development and internationalization support • Extended security control in Actuate 9 SP2 with Dynamic Cell Locking • Cell locking can now be controlled on a user by user basis

19. Performance Improvements Significant Performance Tuning in Actuate 9 SP2 BusinessReport Studio BIRT Reports Interactive Viewer BIRT Reports Information Objects e.Spreadsheets User Responsiveness and Throughput

20. Collaborative Reporting Benchmark • Test conducted at IBM’s leading edge lab in San Mateo, CA • Environment was 8-node iServer cluster, total 64 CPU cores • Near-perfect scalability up to 64 cores for batch generation, transient generation, standard viewing and interactive viewing • 1.8 billion report pages generated per day! • Support for 43,000 active users viewing cached reports • Support for 10,000+ active users running on demand reports • Support for 10,000+ active users interactively viewing reports • Support for 1,000 active users of BusinessReport Studio • 43,000 active users is equivalent to a 430,000 to 4,300,000 user population, depending on typical concurrency rate

21. Collaborative Reporting Benchmark Standard Viewing Capacity and Throughput

22. BIRT Exchange Community Site Centralized Knowledge Hub for BIRT Developers • Access Demos. Tutorials, Tips & Techniques, Documentation, … • Easy for users to contribute content, share knowledge • Enables developers to be more productive and build applications faster • Share • Report designs • Code samples • Technical tips • Download • Documentation • Software • Find • Search, Sort • Rate • Comment www.birt-exchange.com

23. Open Source: BIRT 2.2 Enterprise Reporting: Actuate 9 SP2 Community: BIRT Exchange Learn More… • Technical Summary of New Features: e.Support > Products > New Features • BIRT Exchange: www.birt-exchange.com Summary