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 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
I disagree with the Answer.
The code clearly matches the requirement.
I tested this code: correct answer is A
Requirement Expression type: Value – Description: the re seller average unit price.
In solution Kpi Value is “Large Sales Target”. Hence Select NO.
No explanation for B being the correct answer, I do not understand how this can be correct.
I’m afraid it’s due to “Else-1” without spacing in between.
This is not something Microsoft does.