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