To agree with my colleague, we would need to know the details of the cube structure, perhaps a great deal more, to construct a meaningful MDX query.

Let us know if you can provide the needed information, and we'll try to go from there ...

Thanks.

Bill