OBIEE 11G EVALUATE_SUPPORT_LEVEL

OBIEE 11G EVALUATE_SUPPORT_LEVEL

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