InfoAssist: The future of Ad hoc reporting

1. InfoAssist: The future of Ad hoc reporting Brian Carter June 24, 2009

2. What we’ll cover… • Web 2.0 • Functional Overview • Roadmap • Demonstration

3. InfoAssist: The Future of Ad hoc Reporting Web 2.0 meets BI

4. The swinging pendulum

5. Benefits of a Web 2.0 architecture • Rich – robust and intuitive • Responsive – quickly updates • Look and feel similar to desktop • Zero footprint • Lower Total Cost of Ownership

6. InfoAssist: The Future of Ad hoc Reporting Ad hoc reporting

7. Ad hoc reporting defined Wikipedia: "ad hoc" reporting systems allow the users themselves to create specific, customized queries. Typically this would be via a user-friendly GUI-based system without the need for the in-depth knowledge of SQL, or databaseschema that a programmer would have.

8. InfoAssist: The future of Ad hoc reporting overview

9. Key objectives • Provide a single thin-client tool targeting the Business User • Cutting edge, familiar “Office-like” interface • Create reports, charts, and documents, with minimal clicks • Personalization options • Consolidate all thin client reporting tools

10. Fewer clicks: it’s all in the details • Intelligent interface • Consistency across all output formats • Theme based styling • Artwork • Customizable interface

12. The Need for a New User Interface

13. The Need for a New User Interface

14. http://www.eweek-digital.com/eweek/20090119/?pg=38

15. Functional highlights • WYSIWYG development environment • Single click report/chart conversion • Cube analysis and browsing • Multiple queries in one session

16. New Features

17. New Features

19. Live Preview Cubes Browse Hierarchy Values Browse the Cube Interactively by filtering on the hierarchy Create Filters by dragging values from the field tree to the filter bucket

20. Live Preview Graphs Edit graph components via right-click menus

21. Stacked Measures

22. Advanced Filter

23. Product Roadmap

24. WebFOCUS InfoAssist Roadmap Today Q4, 2009 Future • Familiar Office 2007 Interface • Interactive Report Design • Multiple Output formats • Single click chart/report conversion • Cube analysis • Multiple queries in one session • 508 Certification • Complete Report Assistant Functionality • Complete Advanced Graph Assistant Functionality • Create Synonym • Compose mode • Global personalization • Auto Drill & Analysis • Advanced Filters • Stacked Measures • Live Preview Graphs • Live Preview Cubes • Active PDF Output • Multiple queries open at once • Application Ribbon • Role based personalization • Hold Files • Enhanced Drill Downs • Enhanced Compose Capabilities • Enhanced Graph Capabilities • Enhanced Reporting Capabilities

25. Key Q4 2009 Highlights Q4 2009 Deliver robust authoring environment that satisfy the most demanding design and data analysis needs • Application Ribbon: Pick and choose InfoAssist functionality to embed in a query • Role Based Personalization: Provide each user with only the pieces of InfoAssist that they need • Hold Files: Create multiple step queries that create and use hold files. • Enhanced Compose Capabilities: Extend the Compose mode to include alignment, sizing, and cut, copy, and paste options. Automatically generate a report from an existing chart on the canvas or vice versa. Import already created queries. Insert Lines. • Enhanced Drill Downs: Automatically drill down to the next level of a hierarchy when browsing a cube.

26. Demonstration