You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:
You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must contain:
You need to create the KPI.
Solution: You set the value of the Status expression to:
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
KpiValue and KpiGoal accept a single parameter, that is the name of a Kpi.
In this case “Large Sales Target”.
The solution is B.
5
0