Function WITH clause is not working in BI Publisher report. ORA-32034: Unsupported Use Of WITH Cla

Question

Hello Expert ,

In the TEST instance only, we encounter a problem with some BIP reports.

The same report works as expected in the PROD instance.

According to my analysis, this problem only occurs when we use WITH FUNCTION in the data model.

the Data model works , issue with report only

SagarChadha · Answer

do we have solution to this?

Bharat Agrawal · Answer

Would you be able to share query or archived data model/report? Did you try the report generating using a wizard template?