KPI: Channel Revenue

CollapseAll image

Collapse image KPI properties


 Property   Value 
 Associated measure group   Reseller Sales 
 Description   Revenue realized through the reseller sales channel. 
 Display folder   Financial Perspective\Grow Revenue 
 Status indicator   Cylinder 
 Trend indicator   Standard Arrow 

Collapse image Value expression


[Measures].[Reseller Sales Amount]

Collapse image Goal expression


[Measures].[Sales Amount Quota]

Collapse image Status expression


Case
    When KpiValue( "Channel Revenue" ) / KpiGoal( "Channel Revenue" ) >  1
    Then 1
    When KpiValue( "Channel Revenue" ) / KpiGoal( "Channel Revenue" ) <= 1
         And 
         KpiValue( "Channel Revenue" ) / KpiGoal( "Channel 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( "Channel Revenue" ) 
            - 
            (
              KpiValue( "Channel Revenue" ),
              ParallelPeriod
              ( 
                [Date].[Fiscal].[Fiscal Year],
                1,
                [Date].[Fiscal].CurrentMember
              )
            )
          ) 
          /
          (
            KpiValue( "Channel Revenue" ),
            ParallelPeriod
            ( 
              [Date].[Fiscal].[Fiscal Year],
              1,
              [Date].[Fiscal].CurrentMember
            )
          )  
         ) <=.02
    Then 0
    When ( 
           KpiValue( "Channel Revenue" ) 
           - 
           (
             KpiValue( "Channel Revenue" ),
             ParallelPeriod
             ( 
               [Date].[Fiscal].[Fiscal Year],
               1,
               [Date].[Fiscal].CurrentMember
             )
           ) 
         )
         /
         (
           KpiValue( "Channel Revenue" ),
           ParallelPeriod
           ( 
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         ) >.02
    Then 1
    Else -1
End

Collapse image See also


About this documentation