Forum Discussion
DeepButi
Helper I
Helper IHow to clean filter for unused values
We have an OLAP SSAS cube with a sales fact table and an employee dimension table. The employee table contains all company employees. The sales table contains UserCode ... who created the sa...
DeepButiHelper I
Helper I
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.
DeepButiHelper I
Helper ISorry, 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.
