Sum(YTD(),[MEASURES].[])

[databobjr]

Hi,

I try to user YTD and QTD function, from the OLAP Cube, to create calculate member. But when I put it on a report, it gave me this error:

Formula error - The specified time level type is not found in the time dimension - in the "YTD" function

My time dimension is:
Year
Quarter
Month
Day

Any idea?

Thanks,
Bob Message was edited by: databobjr

[AngelaHall]

Following the example:
http://msdn.microsoft.com/en-us/library/ms145978.aspx

I was able to get the following QTD function to work:
aggregate(qtd([Time].[All Time].[1997]))

as well as:
aggregate(qtd([Time].CurrentMember))

~ Angela

[TSBruce]

You may want to make sure that your Time dmension is set to a type of "Time" and not "Standard". This will ensure that all of the time functions are available to you. If this is set to standard, they will not be.