OTBI Time Series function error

Question

Hi

Does anyone know why the OTBI function AGO("Assignment Event"."# Of Hires", "Time"."Month",1) does not work and give the error:

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27037] Unresolved level: "Time"."Time"."Month". (HY000)

SQL Issued: SELECT AGO("Assignment Event"."# Of Hires", "Time"."Time"."Month",1) FROM "Workforce Management - Worker Assignment Event Real Time"

OK (Ignore Error)

User618255-OC · Answer

I will check these and let you know the results, thank you

Gianni Ceresa · Answer

Other "trick" is to expand it in the left-panel when you can select columns to add to your analysis and then edit the formula of your column and move the edit window enough on the right to still see in the background the expanded hierarchy so you clearly see the names of the levels (table name, hierarchy name, level name).

[Deleted User] · Answer

Your formula is syntactically correct. A little trick you can use to see the actual names is to pull in the hierarchical column into a blank analysis, open it down to the level you want and then check the XML: