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