This discussion is archived
0 Replies Latest reply: Nov 19, 2012 7:30 AM by user13358091 RSS

nqsError:22044 Nesting of Ago or TODATE funct with diff level not supported

user13358091 Newbie
Currently Being Moderated
Hello All,

I am facing an issue while using the timeseries function in OBIEE.

Firstly, I need to calcuate the To-date function for a measure at Year-Level( Time Dimension) and then I need to calculate the Month Ago function on that column, So the function would look like this

"Ago(ToDate(Measure, Year) , Month, 1) "

But it is throwing me an error as shown in the subject line, can you please let me know if there is any workaround for this one.

Let me know if you need more clarification on this one.

Regards
RG

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points