Filter dropdowns on attributes have to show the description in suggestions, but in the SQL should resolve the Key or ID of the dimension in the where clause. This is important to avoid performance issues. The Key columns are index, whereas the description columns are not. Our warehouse is pretty large and houses close to 2 TB data and growing.
Taking a simple example of state table, that has three columns, State_Key, State_Abbr and State_Description. State Description is pulled onto the look as a filter and Tennessee is selected. The SQL generated should be as below for optimal performance.
Select State_Description from State
Where State_Key = 45
Thanks in advance!!