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
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?
Hello Joel,
The evaluete function works, the error just happens when i do drill down.
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
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
