I have a star schema and need to query the data of the fact table. My dimensions are all having keyfields that are used in the fact table. For filtering issues I want to use the descriptions. Unfortunately the descriptions are not indexed in the dimesnion tables so the query is pretty slow.
Is there a way to see the descriptions in the quick filter but in the backend to use the key fields for the query?
In HTML one can use the value property of a drop down for that.