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.