The EVALUATE function is disabled in OBIEE by default. You will get the below error for EVALUATE function in BI Analysis when EVALUATE function is disabled.
"error [nQSError: 43113]
EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE"
If you encounter the above error, then you must set the value of the EVALUATE_SUPPORT_LEVEL parameter to 2 in the NQSConfig.INI file.
The default value of the EVALUATE_SUPPORT_LEVEL parameter is "0", which means that evaluate is not supported.
Locate "EVALUATE_SUPPORT_LEVEL" in NQSConfig.INI file and set it to as below.
# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manage Repositories permission
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.
EVALUATE_SUPPORT_LEVEL = 2;
The NQSConfig.INI file is located at the following location:
<DOMAIN_HOME>/config/fmwconfig/biconfig/OBIS/NQSConfig.INI
DOMAIN_HOME = /u01/Oracle/Middleware/Oracle_Home/user_projects/domains/bi