Pivot Tables: New dimension members show up checked in dropdown

[kaiwiki73]

I've noticed that when distinct new members are added to dimension dat
they show up as checked in a dropdown list when the pivot table i
refreshed.

Is there anyway to disable this so that they don't show up (pre
checked?

Basically, I have a model that depends on a subset of the members
which I have checked in a dropdown, and the rest are unchecked - an
when a distinct new member is added it automatically shows up a
checked in the dropdown list, which gives me wrong answers.

E.g. I have Stock Tickers as a dimension and avg. price as the measure
I have 10,000 Distinct Tickers of which I have only selected the hote
stocks MAR, HLT, and HOT. Now suppose that Google has an IPO an
suddenly shows up as the 10,001st Ticker in my list. When I refresh m
Pivot Table the next day I get GOOG (or whatever its symbol will be
automatically checked and hence factored into my average - all withou
me noticing, becuase there are too many items in the dropdown t
manually check every day.

Ps - I am running this from an OLAP server, but I get the same behavio
for a standard Excel Pivot Table as well

 

[findingbreamo]

I don't have a solution and in fact, I have the exact same problem. s
really interested in anyone with a fix.

Cheers, Bream