# KPI Builder

Document Sample

```					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:
Categories:
Tags:
Stats:
 views: 236 posted: 7/11/2010 language: English pages: 8
Description: for MDX