I am trying to create a dimension to show only customers/orders where the
total sales price > 50,000. I have added a filter to the dimension in the
Source Table Filter on the Dimension Properties.

"dbo"."RevRec2k5Fact"."TotalPrice" > 50000.

The dimension saves fine BUT when I process the cube I am getting the
following error(s):
A member with key 'XXXXXX' (actual order #'s)was found in the fact table but
was not found in the level 'Order Id' of the dimension 'CustOrd50K'.;
Time:6/2/2005 6:17:24 PM
And the cube processing fails.

Well it makes sense to me that this order number would not be in the
dimension because it does not meet the filter criteria. Am I missing a
setting somewhere to allow for dimensions with filters to process without
errors? Any guidance is appreciated.
-Papacito

The error you receive is probably happening during partition processing.
You've restricted dimension not to have certain members but your fact table
still has references to these members

You will need to set a filter on partition as well

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"papacito" <papacito (AT) discussions (DOT) microsoft.com> wrote