In order to achieve the best performance with our queries, we need to perform filtering on the numerical key columns. However, the display values in the prompts need to be textual and user friendly.
In this recipe, we will create a filter that displays the product line list (textual values) but actually filters on the numerical codes (Product_Line_Code).
Create a simple list report with Products/Product and Sales fact / Quantity as columns.
In this recipe, we will create a prompt and examine the differences between using the display value and the use value.