topic Sum(YTD(),[MEASURES].[]) in SAS Web Report Studio

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

databobjr — Wed, 09 Feb 2011 21:01:21 GMT

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

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

AngelaHall — Mon, 21 Feb 2011 14:05:12 GMT

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

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

TSBruce — Thu, 24 Feb 2011 17:36:53 GMT

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.