Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to Configure Fusion HCM BI server to support Evaluate function in OTBI

Received Response
57
Views
1
Comments
Paul Worsley
Paul Worsley Rank 1 - Community Starter
edited Aug 13, 2024 5:04PM in Oracle Analytics Cloud and Server

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

Tagged:

Answers