How to join multiple dimensions for same measures in MDX

See more:

MDX

Hi,

So, I am developing a cube for the first time and here is the situation.

Cube contains multiple dimensions and 1 measure group.
There are 2 same Date dimensions - one for Booking date and one for the stay date. It is connected to the fact on Book_key and Stay_key.

I am writing a MDX query which has to perform following things:
Select {(All Measures in respect to Book Date), (All Measures in respect to Stay Date)} on 0
where Book Date = some date.



So, same measures are to be added in the columns 2 times - 1 each for stay and book date.

Can someone please help me in writing this query?

Thanks,
Naveen