Showing posts with label ENABLE EVALUATE. Show all posts
Showing posts with label ENABLE EVALUATE. Show all posts

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)