Did you forgot to post the error message? Setting that parameter (to 1 or 2) allows OBIEE users to call database functions. Here is the documentation.
Edit: There shouldn't be any impact to existing reports (but you would know better in term's of security who needs what access). Also you cannot do it through EM.
I was in the same boat a while back. I believe setting it at level 2 lets all users call database functions in OBIEE. If I find my reference from my notes, I'll post it over here.
sorry my bad
here you go
Odbc driver returned an error (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [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)++++++++++++++++++++++++++++++++++++++++++++++++
ok, and did you confirm that the report that throws the error uses "Evaluate" in it's criteria? If so change the value of the param to 1 or 2 and test. Here is the 11g doc for the same.
The links explain the usage and what the values mean and possible security vulnerabilities if not set to zero.
Just to add to all above comments:
EVALUATE_SUPPORT_LEVEL value 1 or 2 meaning:
For value 1 Evaluate is supported for users with manageRepositories permission(it is assigned through application policies to an application role of which user is part of)
For value 2 Evaluate is supported for any user.
thanks for your inputs, yes i have noticed EVALUATE function has been used across various fields in couple of reports
guess based on above definition also provided by Syed , i m thinking to go for
VALUATE_SUPPORT_LEVEL = 1;
So once i make these changes, should i have to request my IT team to restart the entire OBIEE servers or is there anything that i could do from my end through EM/Console to have these changes reflected immediately
Please share your inputs
If you set the value to 1 then only users with the manageRepositories permission will be able to run the reports. And normal bi user's doesn't have that permission. But if this is required only for users with that permission then set the value to 1 and restart BI services or if all users need to run reports with "Evaluate" in it, then set to 2 and restart services.And you can restart the services from EM.
Make the change in NQSConfig.INI i.e. define EVALUATE_SUPPORT_LEVEL
EVALUATE_SUPPORT_LEVEL = 1;
Save the file
Through either EM or through command console restart your OPMN managed BIEE Services(coreapplication_obis1,coreapplication_obips1 etc..)
EVALUATE_SUPPORT_LEVEL = 2;
guess i wanted to go with 2 with your explanation,
is there a way to change it from the front end applications, rather than doing this from back end
where i searched for this in the directoty i have 2 of these files NQSConfig.INI
one located under instance/instance1/....../coreapplication_obis1/
Other one is under Oracle_BI/bifoundation/......./OracleBiServerComponent/
Please let me know
You should make the edit in the file itself. And the file is the one under the instance directory. Also take a backup before editing the file.
Thanks for all the info. m all set with this request