KPI: Internet Revenue

CollapseAll image

Collapse image KPI properties


 Property   Value 
 Associated measure group   Internet Sales 
 Description   Revenue realized through direct sales via the internet. 
 Display folder   Financial Perspective\Grow Revenue 
 Status indicator   Cylinder 
 Trend indicator   Standard Arrow 

Collapse image Value expression


[Measures].[Internet Sales Amount]

Collapse image Goal expression


Case
    When IsEmpty
         (
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
    Then [Measures].[Internet Sales Amount]              
    Else 1.10 *
         ( 
           [Measures].[Internet Sales Amount],
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
End

Collapse image Status expression


Case
    When KpiValue( "Internet Revenue" ) / KpiGoal( "Internet Revenue" ) >  1
    Then 1
    When KpiValue( "Internet Revenue" ) / KpiGoal( "Internet Revenue" ) <= 1
         And 
         KpiValue( "Internet Revenue" ) / KpiGoal( "Internet Revenue" ) >= .85
    Then 0
    Else -1
End

Collapse image Trend expression


Case
    When IsEmpty
         (
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
    Then 0  
    When VBA!Abs
         (
          ( 
            KpiValue( "Internet Revenue" ) 
            - 
            (
              KpiValue( "Internet Revenue" ),
              ParallelPeriod
              ( 
                [Date].[Fiscal].[Fiscal Year],
                1,
                [Date].[Fiscal].CurrentMember
              )
            )
          ) 
          /
          (
            KpiValue( "Internet Revenue" ),
            ParallelPeriod
            ( 
              [Date].[Fiscal].[Fiscal Year],
              1,
              [Date].[Fiscal].CurrentMember
            )
          )  
         ) <=.02
    Then 0
    When ( 
           KpiValue( "Internet Revenue" ) 
           - 
           (
             KpiValue( "Internet Revenue" ),
             ParallelPeriod
             ( 
               [Date].[Fiscal].[Fiscal Year],
               1,
               [Date].[Fiscal].CurrentMember
             )
           ) 
         )
         /
         (
           KpiValue( "Internet Revenue" ),
           ParallelPeriod
           ( 
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         ) >.02
    Then 1
    Else -1
End

Collapse image See also


About this documentation