Thursday, 28 February 2013

OBIEE 11g Evaluate Function Error

Error Code : Formula syntax is invalid

[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
SQL Issued: SELECT EVALUATE('LEAST(%1,%2)', 1, 2) FROM "Service - CRM Activities"


 Solution:

1.Change the NQSconfig.ini File.

# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.

EVALUATE_SUPPORT_LEVEL = 2;  

2.Restart The OPMN services.
Then Test It..

Thanks,

No comments:

Post a Comment