You either need to create a member such as below and report on that

create member [Effective Date].[Dates].[YTD] As

Aggregate(

StrToSet("YTD([Effective Date].[Dates].[Date].[" + CStr(DATEPART("YYYY",NOW())) + "-"

+ Right("0" + CStr(DATEPART("m",NOW())),2) + "-"

+ Right("0" + CStr(DATEPART("d",NOW())),2) + "])")

)

or create a YTD measure such as

create member [Measures].[YTD] As

Aggregate(

StrToSet("YTD([Effective Date].[Dates].[Date].[" + CStr(DATEPART("YYYY",NOW())) + "-"

+ Right("0" + CStr(DATEPART("m",NOW())),2) + "-"

+ Right("0" + CStr(DATEPART("d",NOW())),2) + "])")

, [Measures].[Revenue])

Mack