Skip to Content

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply