We were talking to a customer about the new filtering options in Stratum 6.5 and someone mentioned that they have a dimension (I think it was Order number) that has over a million values. The problem this created was that it takes forever for to go in and search for an order number. One reason they were having issues is that the Select Members option for the order dimension was left at the default which is Basic. This means that the search window loads up all the members first (or at least trys!) and then allows the user to select value(s). If it had been set to Advanced the window would come up with no members listed and then you could search for the specific one your are looking for. So….moral of the story is that when you have a dimension with lots of members (product, customer, order etc.) set the search option to Advanced and it should make things much faster. More stuff on this here .