Docstoc

KPI Builder

Document Sample
KPI Builder Powered By Docstoc
					Step 1: Determine Measure

Please paste the measure value:               [Measures].[Quantity]




Step 2: Determine Dimension String - add multiple dimensions here

Please paste the dimension string:            [Account].[Posting].&[1].&[5997].&[5995]




Step 3: Measure and Dimension Strings -> KPI component
      Create New Group using Step 1 and Step 2                     Add <Step 2: Dimension> Into Group




Grouped KPI component:




Step 4: KPI Components -> Final KPI
Debugging information:
                                               IIF ( ( [Measures].[Quantity] , [Version].[Version].&[1] ,
                                              [Account].[Posting].&[1].&[5997].&[5995] ) = 0 , null , ( (
                                              [Measures].[Quantity] , [Version].[Version].&[1] ,
                                              [Account].[Posting].&[1].&[2999].&[2995] ) / ( [Measures].[Quantity]
                                              , [Version].[Version].&[1] , [Account].[Posting].&[1].&[5997].&[5995] )
                                               ) )
IIF ( Current Liab = 0 , null , ( Current Assets / Current Liab ) )



      +         -        x          /         IIF            (         )          null       =          0         ,
KPI Name:




                                     IIF ( Current Liab = 0 , null , ( Current Assets /
KPI Formula:                        Current Liab ) )
Step 5: Display Final KPI

Copy this KPI String into ZAP BI:    IIF ( ( [Measures].[Quantity] , [Version].[Version].&[1] , [Account].[Posting].&[1].&


       Submit                                                                 Clear Screen

ZAP KPI Builder version 1.0 - created on 8 January 2007 - ZAP Technology Singapore
            Stored Values

    Store   ( [Measures].[Quantity] ,          Insert

            [Version].[Version].&[1] ,
            [Account].[Posting].&[1].&[5997]
            .&[5995] )
            Current Liab
    Store   ( [Measures].[Amount] ,            Insert
            [Version].[Version].&[1] ,
            [Account].[Posting].&[0] )
            P&L Value version 1
    Store   ( [Measures].[Quantity] ,          Insert
            [Version].[Version].&[1] ,
            [Account].[Posting].&[1].&[2999]
            .&[2995] )
            Current Assets
    Store   ( [Measures].[Amount] ,            Insert
            [Version].[Version].&[1] ,
            [Account].[Posting].&[0].&[7995]
             )
            Total Costs Version 1
    Store   ( [Measures].[Amount] ,            Insert
            [Version].[Version].&[1] ,
            [Account].[Posting].&[0].&[6995]
             )
            Sales Version 1
    Store   ( [Measures].[Amount] ,            Insert
            [Version].[Version].&[1] ,
            [Account].[Posting].&[1].&[2999]
            .&[1999].&[1395] )
            FA
    Store   ( [Measures].[Amount] ,            Insert
            [Version].[Version].&[1] ,
            [Account].[Posting].&[0].&[8790]
             )


            pers exp
    Store   ( [Measures].[Amount] ,            Insert
,           [Account].[Posting].&[0].&[9190]
             , [Version].[Version].&[1] )


            Int Income
                 Store        ( [Measures].[Amount] ,                   Insert
                              [Version].[Version].&[1] ,
                              [Account].[Posting].&[0].&[9290]
                               )
                              Int Exp
                 Store        ( [Measures].[Amount] ,                   Insert
                              [Version].[Version].&[1] ,
                              [Account].[Posting].&[0].&[8695]
                               )


                              ops exp



ion].&[1] , [Account].[Posting].&[1].&[5997].&[5995] ) = 0 , null , ( ( [Measures].[Quantity] , [Version].[Version].&[1] , [Account].[Pos


                                                             Clear Stored Values
n].[Version].&[1] , [Account].[Posting].&[1].&[2999].&[2995] ) / ( [Measures].[Quantity] , [Version].[Version].&[1] , [Account].[Posting].&
Version].&[1] , [Account].[Posting].&[1].&[5997].&[5995] ) ) )

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:236
posted:7/11/2010
language:English
pages:8
Description: for MDX