Oracle Analytics and AI

ACDC

We are new to Oracle, fresh implementation.

I have tried to use AGO and TODATE functions to sum up and compare ITD figures etc but somehow it errors out when i run. It feels like time levels are not recognised at all.

error:

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. (HY000)

[nQSError: 43113] Message returned from OBIS. (HY000)

[nQSError: 46036] Internal Assertion: Condition levelExprPtr.get(), file server/Query/Optimizer/ServiceInterfaceMgr/Utility/Src/SQOIUMetadataConverter.cpp, line 6521. (HY000)

SQL Issued: SELECT TODATE("- Burdened Cost"."Baseline Burdened Cost In Project Currency", year) FROM "Project Control - Financial Project Plans Real Time"

OK (Ignore Error)

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26122/otbi-time-intelligence-functions-does-not-work

Hi @ACDC,

It seems AGO function is not supported for SAAS BI.

Please take a look into the following Oracle Note & the post for the probable work around and the details.

https://support.oracle.com/knowledge/Oracle%20Cloud/2245339_1.html

Ago Function not working in OTBI — Cloud Customer Connect

Hope this help.

Thank you.