Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to Configure Fusion HCM BI server to support Evaluate function in OTBI
Hi,
I need to use the LEAD / LAG functions in OTBI.
When I do, I get the error below:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
SQL Issued: SELECT EVALUATE('LAG(%1,1,0) OVER (ORDER BY %2)',"Worker"."Person Number","Assignment Event Details"."Effective Start Date") FROM "Workforce Management - Worker Assignment Event Real Time"
Can you please let me know how I configure Fusion HCM BI server to support Evaluate function in OTBI reports.
Thanks
Answers
-
You can't enable EVALUATE for OTBI. See this MOS doc: https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2338216_1.html
0