Click here to Skip to main content
15,439,556 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

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?


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900