What analytic function templates are available in Discoverer?

Discoverer Plus Relational provides easy-to-use templates for the most popular analytic functions. These templates enable you to perform complex business intelligence analysis quickly and easily.

Note: For examples of analytic functions created using templates, see "Examples of using row-based and time-based intervals".

Discoverer provides templates for the following types of analysis:

• Band by rank - creates a number of bands (e.g. quartiles) and places each value into one of the bands according to its ranked list position (for more information, see "Band by Rank dialog")

• Band by value - creates a number of bands (sometimes referred to as buckets) and places each value into one of the bands according to the value (for more information, see "Band by Value dialog")

• Difference - typically calculates the change in values across time (for more information, see "Difference dialog")

• Following value - returns the value that is a specified number of rows or a specified time period after each value (for more information, see "Following Value dialog")

• Group total - aggregates values within a group (for more information, see "Group Total dialog")

• Moving total - calculates a total for the specified number of rows or a specified time period before each value (for more information, see "Moving Total dialog")

• Percent contribution - calculates the ratio of a value to the sum of a set of values (for more information, see "Percent Contribution dialog")

• Percent difference - typically calculates the change in values across time as a percentage (for more information, see "Percent Difference dialog")

• Percent rank - calculates the relative position of a value in a group of values (for more information, see "Percent Rank dialog")

• Percent running contribution - can be used in 80-20 analysis (for more information, see "Percent Running Contribution dialog")

• Preceding value - returns the value that is a specified number of rows or a specified time period before each value (for more information, see "Preceding Value dialog")

• Rank - calculates the ranked list position of values (for more information, see "Rank dialog")

• Running total - calculates the total from the value at the start of the group to each value (for more information, see "Running Total dialog")

Notes

• When you use an analytic function template, you populate the Calculation field with the SQL statement for the analytic function formula. You can manually edit the SQL statement at any time in the Calculation field.

• For more information about analytic functions, see "What are analytic functions?".

• For more information about using analytic function templates, see "How to create a new calculation using an analytic function template".