Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

[nQSError: 22044] Nesting of AGO or TODATE functions with differing level arguments is not supported

I have a metric that uses ago functions to calculate “% Change Year over Year” for a metric. I get [nQSError: 22044] Nesting of AGO or TODATE functions with differing level arguments is not supported.. even though I don't have any nested time series functions.

Here's a pesudocode of my metric definition:

( ifnull(AGO(BaseMetric, TimeHieararchy.Year , 0),0) - ifnull( AGO(BaseMetric, TimeHieararchy.Year , 1),0)) / AGO(BaseMetric , TimeHieararchy.Year , 1)

The BaseMetric is just a distinct count on another column.

Why does OBIS think I have nested time series functions at different levels when all my time arguments are at ‘Year’ level?
Comments
Post Details
Added on Apr 17 2025
#agofuncsion, #obis, #timeseries
0 comments
33 views