urgent :Calculation of mod price in MDX -
09-20-2004
, 11:49 PM
Hi,
I have a RetailPrice measure which is stored at SKU product the lowest
level in the fact table.This price need not be aggregated in the cube.
If we are creating partitions monthly.If i select Jan to March(it can
be dynamic) as time period
I wanted to know is it possible to calculate the mod price for this
measure for the above period by MDX in the cube
It would be great,any one please let me know how can i achieve it
using MDX
Regards
Prasanna |