1 / 18

Accumulation Techniques for Reporting with WebFOCUS

Accumulation Techniques for Reporting with WebFOCUS. Kyle Hachey Systems Engineer. Workshop Objectives. Use WebFOCUS to produce report totals Row and Column Totals Prefix Operators for Counts, Percentages, Minimums, etc. Use Compute to combine selected columns

dom
Download Presentation

Accumulation Techniques for Reporting with WebFOCUS

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. Accumulation Techniques for Reporting with WebFOCUS Kyle Hachey Systems Engineer

  2. Workshop Objectives • Use WebFOCUS to produce report totals • Row and Column Totals • Prefix Operators for Counts, Percentages, Minimums, etc. • Use Compute to combine selected columns • Produce section totals at break points • Subtotal and Recompute • Review report message options • Calculate new summary values with RECAP • Apply conditions to operations with WHEN

  3. W - 4 Providing Totals in Reports WebFOCUS enables you to produce commons types of totals in reports: • Totals for numeric values in rows • Totals for numeric values in columns • Totals for sort breaks in a report • Grand totals at the end of a report

  4. Developer Studio W - 4 The Compensation and Bonus Estimates Report

  5. W -13 Performing Numeric Operations Prefix operators are mathematical functions that are added to the fieldname in a verb phrase. • Can only be applied to column fields. • Cannot be applied to sort fields (BY or ACROSS).

  6. W -13 Performing Numeric Operations (continued) Numeric operations include: • Calculate the average (or mean) of the values of a column • Determine the minimum or maximum value of a column. • Calculate the percentage of a column value to the column total. • Sum and count numeric values.

  7. W -14 Prefix Operators

  8. W -14 Prefix Operators (continued)

  9. Developer Studio W - 15 The Total Compensation Estimate Report

  10. -25 W Review: Providing Totals in Reports To add all numeric verb objects for a row total, use: To total selected fields only, use: To generate a grand total at the end of a report, use:

  11. Developer Studio W - 26 The Compensation and Bonus Estimates Report

  12. W - 37 Review: Section Totals

  13. W - 38 Customized Formatting

  14. W - 39 Customized Formatting

  15. Developer Studio W - 40 The Sales Metrics for All Products

  16. - 46 W Using Recap

  17. W - 64 Review: Handling Messages

  18. Workshop: Review • Use WebFOCUS to produce report totals • Row and Column Totals • Count the number of column values with the prefix operator CNT. • Use Compute to combine selected columns • Produce section totals at break points • Subtotal and Recompute • Review report message options • Calculate new summary values with RECAP • Apply conditions to operations with WHEN

More Related