Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Time intelligence functions does not work.
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
-
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.
Ago Function not working in OTBI — Cloud Customer Connect
Hope this help.
Thank you.
1
