Oracle Database Discussions

Hi Bhaskar,

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.

https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-C2C5B43E-4BB9-4ED7-94DE-D262698DCF98.htm#BIMIG-GUID-C2C5B43E-4BB…

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.

Sherry George,

sorry my bad

here you go

++++++++++++++++++++++++++++++++++++++++++++++++

Odbc driver returned an error (SQLExecDirectW).

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.

https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configfileref.htm#BIESG417

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.

Hi Sherry

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

Regards:

Bhasker.V

Jsglp

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..)

sure

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

Regards:

bahsekr.V

jsglp

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

Regards:

Bhasker.V

Jsglp