Hi,

I am getting a really strange problem when trying to query an olap
cube.

The following MDX results in a "cannot find dimension member" error
through the mdx sample application yet once i browse my the company
dimension and the smaple application loads the members in the dimension
the query works fine. The MDX im using is:

SELECT {[measures].[Rent Passing £]} on columns,
{[Company].[Unmatched], [Company].[Ineligible]} on Rows
FROM Cube WHERE ([Time].[2004].[4].[December])

Any idea why this query would work fine after browsing the dimension
but not before?

Any ideas would be greatly appreciated,

Thanks,

Lee

I have found the problem. I was not using the full dimension syntax.

[Company].[Unmatched]

should have been

[Company].[All Company].[Unmatched]

etc.

The sample app obviously doesn't need the full syntax once you have
browsed dimension.

Lee