I have a dimension and a LOV associated to it. This dimension is not recognizing the associated LOV. Below is the SQL from the LOV
SELECT
distinct dbo.v_ilob_fact.niin, max(dbo.v_ilob_fact.backorder_quantity_total)
FROM
dbo.v_ilob_fact
WHERE dbo.v_ilob_fact.niin IS NOT NULL AND dbo.v_ilob_fact.file_date = @Prompt(Date)
GROUP BY dbo.v_ilob_fact.niin
ORDER BY 1 ASC
Limit 100
I am using MySQL
Your query for the list of values is returning 2 columns. When you associate the list of values to the dimension, you need to specify which of the columns joins to the dimension. Something like the attached:
It looks like my previous screenshot was cut off. When you click on the ellipse (…) by the List of Values, you should get an option to assign a column to map.
check if there are values in return by this prompt
“max” is guessed as the name in lov-mapping, because there is no clear column-name in the sql-output
→ add a name in your sql-statement, e.g. max(dbo.v_ilob_fact.backorder_quantity_total) as max_quantity