error evaluate in drill down

1037520

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

Joel Acha

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

Hello Joel,

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

ArijitC

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