SQL Server 2005 What is the best way to filter a cube dataset based upon a list? If I was using a normal dataset I would create a filter along the lines of "IN(ValueA, ValueB, etc.)" or I would create a table with the values in it and make a join on that. I have tried numerous ways of doing this in my cube dataset and they do not seem to work or are unreliable and/or give me some strange results. This is probably because I am new to this but it does not seem easy or intuitive The challenge is that our look up dimension contains 180,000 + values so it is not practical to scroll through the list and pick them - also the list does not display all the values. What I did was to pick a couple of random ones, make a parameter out of the filter and then I went into the parameter properties and altered the Non-queried default values/ added more so I ended up with entries like so: [Item].[Short Item Number].&[1000963] [Item].[Short Item Number].&[1000964] This seems very long winded and, alarmingly, the numbers changed - I know that may sound odd but it really has happened a number of times to me now. There must be a way to refer to a table? Thanks, Ian