Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 414

<=-.02
Then -1
When ( KpiValue ( "Sales Revenue KPI" ) -
(
KpiValue ( "Sales Revenue KPI" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)) /
(
KpiValue ( "Sales Revenue KPI" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
) >.02
Then 1
Else 0
End
11. Expand the Additional properties section at the bottom of the KPI
template to type a name in the Display Folder combo box for a new
folder, or to pick an existing display folder. The KPI browser will show
all KPIs in a folder separate from other measures and dimensions,
but you can further group related KPIs into folders and subfolders. A
subfolder is created when the folder names are separated by a back-
slash, "\." In the Display Folder combo box, type
SampleKPI\RevenueFolder as shown in Figure 9-28 .