Enable Evaluate in OBIEE 11g

To use the Oracle EVALUATE function in OBIEE, we need to set a parameter in the NQSConfig.INI file in OBIEE 11g.

Steps

1) Take the backup of NQSConfig.INI file located at OBIEE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

2) Edit the original NQSConfig.INI file

This is what you will see by default in the NQSConfig.INI file
---------------------------------------------------------------

1. EVALUATE_SUPPORT_LEVEL:
2. 1: evaluate is supported for users with manageRepositories permission
3. 2: evaluate is supported for any user.
4. other: evaluate is not supported if the value is anything else.
   EVALUATE_SUPPORT_LEVEL = 0;
   ---------------------------------------------------------------

3) Change the parameter as follows: EVALUATE_SUPPORT_LEVEL = 2;

4) Save and restart the BI Server (From Enterprise Manager)