SAP BO: ALERTS for HIERARCHY
A. Q: How to define the alerts for different values for depending on level.
Create variable at report to find out the level number for hierarchy
Drill Level =If Length(DrillFilters(“=”))=0 Then 0 Else ( Length(DrillFilters(“=”)) – Length(Replace(DrillFilters(“=”);”=”;””)))+1
Note: we need use unique character as the parameter for DrillFilters like above “=”, which is not part of the data at any level of the hierarchy .
Example Hierarchy:
Level0: Executive Director
Level1: Deputy Director
Level2: Executive Assistant
By using above variable we can find out the level number when we are in drill
Use:
We can define the alerts for different values for depending on level.
Requirement:
Define the alert for target depending on level
|
Hierarchy Level |
Exceed the Target (Alert :Green ) |
Meet the target (Alert :Yellow) |
Below the target (Alert:Red) |
|
Executive Director |
>=10000 |
>10000 and <=5000 |
<5000 |
|
Deputy Director |
>=1000 |
>1000 and <=500 |
<500 |
|
Executive Assistant |
>=100 |
>100 and <=50 |
<50 |
1. Define alert like below:
Alert(Green):
DrillLevel=0 and target >=10000
Or
DrillLevel=1 and target >=1000
Or
DrillLevel=2 and target >=100
SubAlert1(Yellow):
DrillLevel=0 and target >10000 and target <=5000
Or
DrillLevel=1 and target >1000 and target<=500
Or
DrillLevel=2 and target >=100 and target<=50
subAlert2(Red):
DrillLevel=0 and target <5000
Or
DrillLevel=1 and target<500
Or
DrillLevel=2 and target <50
2. 2. Assign alert to target column.