HTML Composer

1. HTML Composer Scott WannerTechnical Account Manager, Dallas

2. HTML Composer – Agenda • Where does the HTML Composer fit within the user pyramid. • Where can you use it. • Why you should be using it. • Things you can use/do with it. • Build a couple example with it. • Open the floor up for questions.

3. HTML Composer – Where does it fit 3+ Clicks – Developers 2 Clicks – Analytic/Exploration Capability • OLAP Analysis against any DBMS - no staging necessary • Full ad-hoc reporting • No specialized software required UserComplexity 3+ Clicks • 1 Click – User Requested Reports • Intuitive interface/self-service • Parameters = max. flexibility • Selectable output formats • Optional drill-down to data • No specialized software required Clicks 2 Click 1 Click 0 Breadth of Users 0 Click – No Effort Reports • Delivered to recipient via email • No technology barriers

4. HTML Composer – Where can you user it. • HTML Composer is part of our Developer IDE Environments. • Developer Studio. • Self-Service Applications. • WebFOCUS Portal. • Report Developer • WebFOCUS Portal.

5. HTML Composer – Why you should be using it. • Reduces development time. • User friendly development environment. • Provides common development environment. • Feature rich providing integration of non-WebFOCUS components. • Easier Maintenance.

6. HTML Composer – Things You Can Use/Do With It. • Add ActiveX controls. • Tab control. • Flash control • Load NON-WebFOCUS content. • Create very appealing dashboards. • Create Rich Internet Applications (RIA’s). • Create guided Ad-Hoc interfaces. • Chain controls to prevent invalid requests. • Save parameters • Embed WebFOCUS Content • In Short: The Sky is Your Limit.

7. HTML Composer Guided Ad-Hoc – Reasons to use. • Give the user the ability to customize there reports. • Reduce the number of reports. • Control what data the user case access. • Control how the user can access the data. • Reduces the # of report requests sent to IT. • Gives the user the ability to access the data when they need it and in the desired output format they want it. • Hides the complexity of have to know how tables relate. • No additional cost.

8. Structured Ad Hoc – Variance Report 1 Click User Enabling the user to choose what is displayed on a report in a controlled environment empowers them to create any number of report combinations from a single html selection screen. Imagine the time saved when the user can easily pick and choose columns, filters, sort groups and more from standard browser controls such as list boxes and radio buttons. The user can select several measures and hierarchy levels, resulting in thousands of unique combinations. Without this flexibility, thousands of unique physical reports would have had to have been created. • Solution/Feature Point • Explicit and Even novice web users can select report elements such as columns, measures, sort groups, filters, and output formats to customize a report to meet their individual needs. • Automatic conditional drill-thru to any other report, program, location, or application allow users to navigate to any information online. ** Information Builders Confidential **

9. 1 Query and Analysis – Robust Excel Integration Click User Output WebFOCUS reports to Excel and eliminate the need to re-key information thus increasing the accuracy of the spreadsheets the are delivered throughout the organization. WebFOCUS’s Excel output preserves the report formatting and drilldowns to detailed data. Automatic generation of native Excel formulas provides the ability to perform "What-if” analysis as well as adding another level of auditability. Burst output to different worksheets based on a different data value or simply combine multiple reports into a single workbook. • Solution/Feature Point • Information from multiple systems easily published into one high quality Excel document. • Unlimited unique report worksheets can be created within one workbook in a single step. • Information can be bursted into unique worksheets within a workbook based upon a sort group. • Excel Worksheet limit of 65,000 lines can be automatically parsed into multiple worksheets. • Excel Workbooks created with full formulas support. ** Information Builders Confidential **

10. 1 Structured Ad Hoc – Self Service Reporting Click User Enabling the user to choose what is displayed on a report in a controlled environment empowers them to create any number of report combinations from a single selection screen. Imagine the time saved when the user can easily pick and choose columns, filters, sort groups and more from standard browser controls such as list-boxes and radio buttons. The user can select several measures and hierarchy levels, resulting in thousands of unique combinations. Without this flexibility, thousands of unique physical reports would have to be created and maintained. • Solution/Feature Point • Explicit and Even novice web users can select report elements such as columns, measures, sort groups, filters, and output formats to customize a report to meet their individual needs. • Automatic conditional drill-thru to any other report, program, location, or application allow users to navigate to any information online. • Save parameters for future use to save time for report configurations used often. • User could be granted access to schedule report to run automatically and forward results in email or to the library. ** Information Builders Confidential **

11. HTML Composer Demo TIME

12. HTML Composer – Wrap Up YouTube Videos. • Key Word Search: WebFOCUS TexasStingray. • More Videos to come.

13. HTML Compose Questions