0 Replies Latest reply: Nov 19, 2012 9:30 AM by user13358091 RSS

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

    user13358091
      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