Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets. You identify the following metrics for employees:
-Ninety percent or greater relative to sales target values is considered on target.
-Between 75 percent and 90 percent is considered slightly off target.
-Below 75 percent is considered off target
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
A. Yes
B. No
I agree with this one.
From the scenario “Ninety percent […] is considered on target” is not compatible with the code “>0.9 THEN 1” because ninety percent -exactly- would not be considered as on target with such code.