OBIEE EVALUATE function not working — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE EVALUATE function not working

Received Response
101
Views
9
Comments
2985260
2985260 Rank 2 - Community Beginner

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

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    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

  • 3068122
    3068122 Rank 4 - Community Specialist

    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
  • 2985260
    2985260 Rank 2 - Community Beginner

    I did restart the services. Both the environments have EVALUATE_SUPPORT_LEVEL = 2. its strange that how one works and the other doesn't.

  • 2985260
    2985260 Rank 2 - Community Beginner

    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.

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    What version you have. Check if this bug applies to the environment.

    Doc ID 1922648.1

  • 2985260
    2985260 Rank 2 - Community Beginner

    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.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Compare your NQSconfig files from both the environments using some text file compare tool to see if you made any accidental errors.

  • 2985260
    2985260 Rank 2 - Community Beginner

    Yes I did compare and they both are identical.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.