error evaluate in drill down — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

error evaluate in drill down

Received Response
11
Views
3
Comments
1037520
1037520 Rank 4 - Community Specialist
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

Hello everybody,

I got this error in a pivot table when i try doing drill down:

Cannot function ship the following expression: EVALUATE

There are a field that is calculated with evaluate function.

Can anyone help me ?

Thanks

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    You'll need to help us here if you want us to help you. You'll need to provide a bit more information - some screenshots of the code would also be of help.

    Have you correctly set the EVALUATE_SUPPORT_LEVEL parameter in your NQSconfig.ini file?

  • 1037520
    1037520 Rank 4 - Community Specialist

    Hello Joel,

    The evaluete function works, the error just happens when i do drill down.

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    You need to provide more information on this as Joel said before. Like, how you are drilling down on the report. How your report looks like. What evaluate formula you are using with your database. If the evaluate formula in the formula section of the analysis or in the filter section. etc etc.

    When you use evaluate you bypass your business model . So, most of the time you will be able to figure out the issue by studying logical/Physical SQL generated by your model.

    Thank You

    Arijit