Skip to Content
0
Former Member
Jan 11, 2011 at 03:18 AM

dimension formula MDX

30 Views

Hi expert,

I wish have a MDX formula in my account dimension..

The requirement is ..

get_bigger(%TIME_COMPARE%)

{

iif( time.currentmember.value >= %TIME_COMPARE% , time.currentmember.value , %TIME_COMPARE%.value)

}

%TIME_COMPARE% is a member from time dimension,

%TIME_COMPARE% will be from a property from my current category...

How actually to write this in correct syntax in MDX ???

THANKs