MDX Calculation

#1

MDX Newbie...

Have two measures in single fact table, measure1 and measure2. Have
attribute in related dimension, attribute1;

need to create calculated measure that is;
attribute1 * (measure1/measure2)

What is the MDX?

thx

jc

#2

Add Calculated Members in the cube
As CalcMeasure1
([Measures].[Attribute1],[Measure1].[Level].&[ID])
And CalcMeasure2
([Measures].[Attribute1],[Measure2].[Level].&[ID])
And CalcRatio
([Measures].[CalcMeasure1]/[Measures].[CalcMeasure2])

"jfcarver" wrote:

Quote:

MDX Newbie...

Have two measures in single fact table, measure1 and measure2. Have
attribute in related dimension, attribute1;

need to create calculated measure that is;
attribute1 * (measure1/measure2)

What is the MDX?

thx

jc

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX Calculation

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX Calculation - 12-21-2005 , 03:07 AM

RE: MDX Calculation - 01-03-2006 , 02:50 PM