hi,

I need to use three dimensions in an MDX select statement
in the row level. I tried it with the cross join but its
not working. can anyone help me in sorting this one out?

plz suggest me if there are any forums for MDX.


actually my result must be like this :

Column1 column2 column3

Dim1

Dim2

Dim3

Is this possible ? if so, plz help me.

Thank you

Bye,

With 3 dims you must nest Crossjoin functions. An easier way is to multiple
the sets, such as:

{ Drink.Children * {USA, Canada} * Measures.Members}

public @ the domain below
www.tomchester.net

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