Component Solution Services REC02F Uživatelský manuál stáhnout pdf (Strana 53)

Tips Recipes Brio 2002

Section Type: Pivot section

Tip Name: Fact-based Delta Trends

Purpose / Use: To analyze percent changes from one year to the next, and highlight

those areas where the average year-to-year percent change is greater

than a particular target.

Sample File: Not available to the public

Steps to Produce: This is another analysis that takes some preliminary set up before it can

be created.

1) In the Result section, break out the dollar amounts by year (i.e., create dimensionalized

facts). For example, add a new Computed Item for 1992 called Rsrc_1992. Define the

formula as:

if (Budget_Year='1992') {Gross_Budget} else {0}

Repeat the creation of a dimensionalized fact for each year you want to analyze.

2) Insert a new Pivot. Add the appropriate categories to the left-side labels. Add the

dimensionalized facts to the data area in the order they should be analyzed.

3) For each year-to-year comparison, add a Computed Item to the Pivot. For example, for the

1992-to-1993 delta, name the item Change 1993, and define its formula to be:

if ((Rsrc_1992 != null) && (Rsrc_1992 != 0)) {

if (Rsrc_1993 != null) {

(Rsrc_1993 - Rsrc_1992) / Rsrc_1992

} else { -1 }

} else {

if (Rsrc_1993 != null) { 1 }

else { 0 }

}

1 2 ... 48 49 50 51 52 53 54 55 56 57 58 ... 77 78

Žádné komentáře

Component Solution Services REC02F Uživatelský manuál Strana 53