Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE EVALUATE function not working

We have OBIEE and I had to use EVALUATE function for an analysis. I have changed the NQSConfig.ini as mentioned in 1488008.1. We get the desired results in Dev, but in CERT, we still get the error [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. Checked the RPD functions and both the environments are identical. Can anyone please guide.
Thanks,
Rakesh.
Answers
-
Did you restart the services after you made changes in other environment? What is evaluate support level in new environment ? is it 2? if it is 1 then check if the user has manageRepositories permission.
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.
Thanks
Arijit
0 -
Hi ,
- Stop opmn services (or you can stop only obis component)
- If you are using OBIEE 11g , you can do it using "[INSTANCE_HOME]\bin"opmnctl.bat/sh" stopall. If you are using OBIEE 12c , you can do it using "[DOMAIN_HOME]\bitool\bin\stop.cmd/sh" -i obis1
- Backup NQSConfig.INI
- set EVALUATE_SUPPORT_LEVEL = 2
- If it is 11g then start opmn services , if it is 12c the use [DOMAIN_HOME]\bitool\bin\start.cmd/sh
- Check report that you use evaluate function
0 - Stop opmn services (or you can stop only obis component)
-
I did restart the services. Both the environments have EVALUATE_SUPPORT_LEVEL = 2. its strange that how one works and the other doesn't.
0 -
Yes, i did follow all the processes you mentioned, but we are still facing the issue. Please let me know if there are any other steps which we are missing.
Thanks,
Rakesh.0 -
What version you have. Check if this bug applies to the environment.
0 -
We have 11.1.1.7.140415. I am not sure if it qualifies as a bug because we have the same version in Dev and Test. It works fine in Dev but not in Test.
0 -
Compare your NQSconfig files from both the environments using some text file compare tool to see if you made any accidental errors.
0 -
Yes I did compare and they both are identical.
0 -
With this being evaluate could the differences be on the underlying databases, can you check a use of a function that is available to all on the DB like "nvl" (assuming it is Oracle DB) just to double check that the problem is evaluate and not rights on the function that you are trying to call on the DB.
0