Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Time intelligence functions does not work.

Accepted answer
14
Views
1
Comments
ACDC
ACDC Rank 3 - Community Apprentice

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)

Best Answer