Thank you Fernando for taking the time to find the workaround. It works for me too It is strange to see, the same query gets executed in normal run in the database, whereas in BIP we have to say Oracle's sql is a non standard sql Regards, Donald

Please let me know if you come across any solution Good luck!

Please let me know if you come across any solution Good luck!

Hello Ishan Agarwal I am still looking for a solution for this issue. However, I approached writing a data model with one data set whihc has a WITH CLAUSE query. I suupose the other option to the desired output would be instead of using Excel, youcan define the template in MS Word. In the report output option you give the…

Good one, I will remember that, "We have two pieces of software...." Regards, Donald

Hello Fernando, We are working with Oracle Cloud Financials, so creating the function in database is not possible and therefore the use of FUNCTION in the WITH clause. Thank you for spending time on this issue. Would love to hear how to get around it. If I come across any solution,will keep you updated. Regards, Donald

Hello Fernando, Yes I noticed that := assignment was creating the problem, thank you. But in a PL/SQL function you have to assign the values to a variable in that method, whereas BI Publisher doesn't accept it. How to overcome this issue in BIP? Regards, Donald 

Engine Log File 2.txt attachment Regards, Donald

Hello Fernando, Thank you for taking the time to look into the issue and for your reply. The query works fine outside BI Publisher, no problem. I tried to add alias to the columns in the main query, no benefit. I have attached the engine log file for your reference. Also, below change I did, discable statements FOR LOOP…

Thank you Aman for your solution. It was a browser problem. In Chrome I was not able to see the 'Add Column...' whereas in MozillaI was able to create it as per the steps you mentioned. Regards, Donald

Hello Aman, Attached the catalog file for your reference. Regards, Donald

Hello Aman, Thank you very much for the document. Something new I learned. Created a new OTBI with same Subject Areas, with 3 columns and they worked like you have mentioned in your document. I could see a new column coming up in the 2nd Subject Area. ------------------------------------ The Actual OTBI Report…

Hello Aman, I had a look at the test catalog file of yours and tried to do the same,but not success. I have attached a document with the steps I performed and my questions stated in it. There are a few other OTBI reports similar to this ones which I need to modify as well Could you please take a look at the same and…

Thank you Aman for taking the time to provide the guidance. I will try to apply and will keep you updated. Regards, Donald

Hi Sandeep, Thank you for your reply and tips. I redo the for each goup in the template using the wizard and took the main group outside the table. Now it works as expected. If in future such a error message occurs then I will remember your tips to use. Thanks again for your help. Regards, Donald