Forum Discussion
How to clean filter for unused values
DeepButi unless I ammissing something why can't you use just the User_Code field in the Sales_table as filter?
Are you bringing any other info from the User_Code table?
We use the User_code field on the filter. And it works.
The problem is, there is data on the fact table for just a few User_code values. But the filter shows all user_code values.
In the fact_table there is data for say 5 diferent User_code values, but there are more than 200 diferent values on the filter list. so selecting the one you are interested in is extremely annoying. The filter itself becomes useless because there is too many values with no data associated.
Sorry, I didn't read your post carefully. The User_code in the fact table is not available as a filter, it's a key to the related dimension on the cube, so it's not a measure. Only measures are available as data.
