Traditional web-based reporting with SAS BI tools

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

Reply
Contributor
Posts: 22

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

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
SAS Employee
Posts: 238

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

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
SAS Employee
Posts: 37

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

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.
Post a Question
Discussion Stats
  • 2 replies
  • 444 views
  • 0 likes
  • 3 in conversation