Hello,
I'm having a very wierd problem.
I have an AS 2000 + SP4 installed.

When i'm runing the following simple MDX query, i get and error message
saying
"cannot find dimension member [Product By Categor].&[testMember1]".

select non empty {[Measures].[Redemption Qty]} on columns,
non empty {[Product By Categor].&[testMember1].children} on rows
from [Promotions]
where ([Store by Chain].&[M22683])

HOWEVER, if i'm excuting the following MDX query, then afterwards i can
run the
original query and get results:

select non empty {[Measures].[Redemption Qty]} on columns,
non empty {[Product By Categor].&[Parent1].children} on rows
from [Promotions]
where ([Store by Chain].&[M22683])

Any help will be appreciated.

Yaniv Inbar
Retalix

Found the problem but i don't understand why it happends on some
members while it doesn't on the other members.

When i used the full name of the member,like this:
{[Promo Retail Store
Day].&[M22683].&[M22683S2].&[M22683S2P2001683].children} on rows

instead of:
{[Promo Retail Store Day].&[M22683S2P2001683].children} on rows

I got results.
This behavior is not consist - sometimes it happends, and sometimes it
doesn't.