Hello all,

I've got an interesting case here. When I want to slice a dimension in an
MDX query, I get an error saying that the dimension member doesn't exist. If
I execute another MDX query to retrieve the members of the dimension, it
runs without error and show that the member is actually there. Here's the
interesting part: after that query if I run the exact same query that didn't
work, it runs smoothly. The queries are below. Any ideas?

Doesn't work:

with member Measures.dummy as '1'
select {Measures.dummy} on axis(0)
from x_20040809095631
where (branchdim.x_3180000003)

Error Message: unable to open cellset Formula Error - cannot find dimension
member ("branchdim.x_3180000003") - in a name binding function

After this query:

with member measures.dummy as '1'
select {measures.dummy} on axis(0),
{branchdim.members} on axis(1)
from x_20040809095631

It runs without errors.

Thanks,

Cagdas Ucar (Chadash Uchar)
Exametric, Inc.
Software Engineer