MDX query for displaying all the dimension in a row

I have cube which have 6 dimensions.

I want to display all the dimsion members in a row . Can anyone help me with the MDX query for the same

e.g. suppose the dimension are dim1, dim2, .............

Now I want to retrieve data in the form of table as

Dim1.........Dim2...................Dim3............Dim4...............

Val1..........Val2....................Val3...............Val4................

Is there some way to inner join the data in MDX as in Sql. I mean just like we have inner join in SQL is there any MDX equivalent

e.g suppose we have three tables A,B,C and these three are related through primary foreign key relation ( A conatins the refernce for B and B in tuyrn contains the reference for C).

Now these three table are used to form a Cube and the column in these are tables form a dimension. Nwo can I join these three tables and show the data