I have a cube that has 3 diemsions. I am using Chartfx to display the data
visually.
I need to show all the dimensions in the cube.
I can use NonEmptyCrossJoin to get to 2 of the dimensions, but I am unsure
of how to return more.
Ideally, I would like to return the whole cube via an mdx query.

Any help is greatly appreciated.
Thanks

"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote

If you are using a somewhat recent version of ChartFX (and the OLAP
extension) you can write your MDX like this

SELECT XX on axis(0),YY on axis(1), ZZ on axis(2) from Cube

Regards,

JuanC