KPI properties
| name | value |
|---|
| name | Revenue
|
| description | Total revenue from operations.
|
| id | KPI 10
|
| display folder | Financial Perspective\Grow Revenue
|
| associated measure group id | Sales Summary
|
| trend graphic | Standard Arrow
|
| status graphic | Cylinder
|
Value
[Measures].[Sales Amount]
Goal
Case
When IsEmpty
(
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
Then [Measures].[Sales Amount]
Else 1.15 *
(
[Measures].[Sales Amount],
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
EndStatus
Case
When KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) > 1
Then 1
When KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) <= 1
And
KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) >= .85
Then 0
Else -1
EndTrend
Case
When IsEmpty
(
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
Then 0
When VBA!Abs
(
(
KpiValue( "Revenue" )
-
(
KpiValue( "Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
) <=.02
Then 0
When (
KpiValue( "Revenue" )
-
(
KpiValue( "Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
) >.02
Then 1
Else -1
End