Hello,
Imagine i have a very simple cube with a fact table which the key is the product. I have two measure: MEASURE.PRICE, MEASURE.WEIGHT and some dimensions
If i create a calculated member
MEASURE.CALCUL = MEASURE.PRICE/MEASURE.WEIGHT
At any hierarchy of my cube i have
MEASURE.CALCUL = sum(MEASURE.PRICE)/ sum(MEASURE.WEIGHT) for the current set
Now immagine i want to calculate this ratio in the fact table to calculate MEASURE.PRICE/MEASURE.WEIGHT for each product and after calculate the average of the ratio.
How can i do that in MDX ?
I know it's more simple to do this in sql with a calculated column for exemple but i want to know how to do in mdx
Thanks a lot