When using Evaluate Function in OBIEE 11g
Error : 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 "Disclosures - Encumbered Assets"
Resolution
Change the setting in the nqsconfig.INI
location of File : $MW_HOME/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1
Edit nqsconfig.INI and Change the setting to 2
# 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;
Save changes and Restart the OPMN Services
--Start Services
$MW_HOME/instances/instance1/bin/opmnctl stopall--Stop Services
nohup $MW_HOME/instances/instance1/bin/opmnctl startall &
