Wednesday, August 22, 2012

SAP-BI@Calculated Key Figure

Calculated Key Figure:-
----------------------
* When we calculate a new keyfigure based on the existing Keyfigures by performing some calculations and using some pre-defined functions.
* When we use Calculated Key figure it performs the same calculation through out the entire coloumn.
* Functions:-
-------------
- Basic Functions:-
-------------------
1) High(**) - Power of
 ex:- 2 high 5 = 2^5 = 32.
- Percentage Functions:-
-------------------------
2) Percentage Share(%A):- To calculate    Percentage.
 ex:- 40 %A 200 = 20.00%.
3) Percentage Variance(%) :- To Calcualte the         Percentage on         the Variance      (difference) on 2     operands.
 ex:- 40 % 200 = -80.00 %.
- Data Functions:-
------------------
4) Count - Value =1 if operand is not equal to 0 and if the operand is equal to 0 then it returms 0.
 Ex:- Count(12) = 1.
      Count(0)  = 0.
5) Date :- This function converts the numeric value into Date format by counting the number of days from 01.01.0001.
 ex:- Date(14) = 15.01.0001
  01.01.0001 + 14 days =      15.01.0001.
6) Delta :- Value =1 if operand is equal to 0 and if the operand is not equal to 0 then it returms 0.
 Ex:- Delta(12) = 0.
      Delta(0)  = 1.
7) NODIV - We use this function to control divide by Zero exception by converting infinite value into 0.
 Ex:- NODIV( 1500 /0 ) = 0.
8) NODIM - This function can be used to see the Key figure value without unit dimension.
 Ex:- if we have Revenue as 150.00 INR Then NODIM(Revenue) = 150.00.
 Ex:- if we have Quantity as 50.00 KG Then NODIM(Quantity) = 50.00.
9) NOERR - We use this function to control the exceptions when the keyfigure is not able to define the currency/unit for it.
10) Time :- We can convert the numeric value into time format by counting each value as one second starting from 00:00:00.
 Ex:- Time(100) - 00:01:40.
- Mathematical Functions:-
---------------------------
- Boolean Operators:-
---------------------

































Labels: , , , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home