Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

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

Received Response
81
Views
1
Comments
KHALED IHADDADENE
KHALED IHADDADENE Rank 0 - Community Observer
in Oracle Transactional Business Intelligence

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

Capture.JPG

Answers

  • Bharat Agrawal
    Bharat Agrawal Rank 3 - Community Apprentice

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