I would like to calculate some measures in my dimensional cube.
The measures available in my cube are:
- occupancy rate (by hotel)
- average room rate (by hotel)
I would like to calculate the MPI (Market Penetration Index) and ARI (Revenue Generated Index) using MDX
MPI = average occupancy rate of hotel / average occupancy rate of competitors
ARI = average price of hotel / average price of competitors
I have 5 hotels in my cube.
Thank you for your help.