Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus 11g Release 1 (11.1.1) Part Number B4010502 


PDF · Mobi · ePub 
Use this dialog to create a percent running contribution calculation. A percent running contribution calculation can be used for Pareto analysis (sometimes referred to as 8020 analysis). Pareto analysis calculates how the running total contributes to a group, and expresses the result as a percentage. For example, you might want to know how the top five stores contribute as a percentage of annual sales.
This type of analysis is sometimes referred to as reporting analysis.
For more information, see:
"What are analytic functions?"
"How to create a calculation using an analytic function template"
Percent running contribution on
Use this drop down list to choose the item for which you want to calculate the running total. For example, you might choose Sales SUM to calculate a percent running total of sales values.
Order rows by
Use this drop down list to specify how to order the values. You typically order by the item specified in the Percent running contribution on drop down list, or a time period item.
Use the adjacent drop down list to specify whether to order values in ascending order (that is, Lowest to Highest) or descending order (that is, Highest to Lowest).
Then order rows by
Use this drop down list to specify a secondary order for the values. For example, you might choose City to sort values on city within month.
Use the adjacent drop down list to specify whether to order values in ascending order (that is, Lowest to Highest) or descending order (that is, Highest to Lowest).
Restart percent running contribution at each change in
Use this list to specify the groups to be used to arrange results into groups (sometimes referred to as partitions).
For example, to calculate the percent running contribution of each store in relation to all stores for each year, you might choose Calendar Year.
If you do not specify a group, Discoverer treats all worksheet values as a single group.
Calculation
This readonly field displays the underlying formula that you are building as you specify values for the fields above. This formula is updated each time you change one of the values in the fields above. When you click OK, the formula is transferred to the Calculation field in the "New Calculation dialog" or the "Edit Calculation dialog".