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 Answer.
This code is not valid.
The KPIValue function must refer to the KPI Name which is “Large Sales Target”.
The correct code may have been obtained by replacing KPIValue(“Reseller Average Unit Price”) with KPIValue(“Large Sales Target”).
https://docs.microsoft.com/en-us/sql/mdx/kpivalue-mdx?view=sql-server-ver15
Correct answer is B