Have set up a filter on a dimension and have processed the dimension and
know that when viewing the dimension the filter is working.

When I process the cube, I get a message saying that 'A member with key
'2002-2003' was found in the fact table but was not found in the level
'Fiscal 'Year' ' This is in fact one of the years that I have not included
in my Source Table Filter on the dimension.

I do want this data in the cube but not in the filter that it is not
included in.

Any help appreciated.

Thanks - Dave

Can you explain further what you want to see in the cube - how can
(2002-2003) data be included if that date range is filtered out of the
dimension?


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If you want the data in the cube then you'll have to change the time
dimension member that the value is for. Mind you - if you do that your cube
will be showing untrue results.

What exactly is your requirement here? Something isn't quite right.

"Dave Williams" wrote: