MDX Calculation

SSAS and SSRS
1

Hi,

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.

Regards,

2

Hello Did you manage to find your formula
I would be very intersting in the samne question for an hospital.

Best regards