Hello,

Is there a way for me to access the integer value of the current
month of the time dimension(ex. January =1,February =2,
March=3...December=12). The month level has a member key
column(DatePart(month,TransactionDt_Dim"."transact iondt")).

so my formula would be Total Assets/[Integer value of the current Month]

thanks....


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can reference the (olap) key which may or may not be the month number:

Time.CurrentMember.Properties("Key")

public @ the domain below
www.tomchester.net

"Leo Francis" <joel_idol (AT) yahoo (DOT) com> wrote