SSAS - KPI’s – How Explanation of KPI Makeup - FourMoo | Fabric

Below is an overall description of what is needed for the KPI’s when creating them in BIDS

1. After you click on New KPI you will have a window shown below and underneath the picture are the details required for each section:

a. Where it says Name:

i. This will be the name for your KPI

ii. NOTE: Make sure that it is descriptive and makes sense to the end user

b. Associated Measure group:

i. This is to which measure group you are associating the KPI.

c. Value Expression:

i. This is where you will use a measure to get the actual value of your KPI at Run time.

d. Goal Expression:

i. This is the goal or what you would like your KPI to get to

ii. EG:

1. You have people logging into your system and the more than can log in every minute the better.

2. So it is decided that 500 logins per minute is the goal.

3. Then in the Goal Expression you would put 500

e. Status Expression:

i. This is where you define that status is good, ok or bad for your gauge.

ii. NOTE: You can change the status indicator to one that makes the most sense.

iii. With the Status Expression it can also have three values

iv. EG:

1. 1 is always good

2. 0 is always Ok

3. -1 is always Bad

f. Trend Expression

i. This is where you define what the trend is for the KPI, meaning is it currently getting better or worse.

ii. NOTE: You can change the Trend indicator to one that makes the most sense.

iii. With the Trend Expression it can also have three values

iv. EG:

1. 1 is always good

2. 0 is always Ok

3. -1 is always Bad

SSAS – KPI’s – How Explanation of KPI Makeup