Thanks @Bret Grinslade - Oracle Analytics-Oracle . We are trying that work around as well. But we have around 15 subject areas with the similar measure names, so it would be a big change to do and also to let the users make aware of it. Is there any bug raised for this issue which I can share with the customer? if there is…

Thank you @SteveF-Oracle and @Avinash Krishnaram-Oracle

Thank you @MandeepGupta , @Sumanth V -Oracle

Hi @Shantaram-Oracle , Actually the issue I saw was that the Excel export does not have any data, only the column names. Suppose using the parameter filter I can see 4 rows filtered out in the report, when I export to csv I can see these 4 rows exported but when exported to Excel there isn't any data except for column…

Thanks @SteveF-Oracle . I am doing the same now after the same confirmation from the SR.

Hi @GayathriAnand-Oracle , I have tried it in the latest Nov 2023 OAC version but it still shows the same issue. Can you please specify which version are you talking about.

Hi @Madasamy - Oracle-Oracle , When I installed the Sep 2023 version admin tool it gave the below version same as you have mentioned. Version 12.2.4.0.0 And even with the Sep 2023 Admin tool we get the same warning. Good to know that the consent to warning does not raise any issue. But do let me know if any issues. Thank…

Hi @TetyanaH-Oracle , Yes the issue is presenting itself when using canvas filter bound to a parameter. Yes will raise an SR.

Hi @Madasamy - Oracle-Oracle The use case is same as you have suggested. I am using the below version So when I open the rpd in cloud mode and then try to save it in local it gives the below warning. And I do have the option to click 'Yes' and continue but wasn't sure if that is recommended or not.

Thank you for the response @Federico Venturin . I will check on these options.

This would be really good to have. Currently it becomes very difficult to understand the first calculation inside the second. This functionality would bring an ease to use the calculations/expressions.

The log for Agent executions would help in understanding the executed tasks better.

Hi Palak, The error is related to the syntax of the formula. In the comparison of the case when statement the date is being subtracted from days , that doesn't seem to be correct, Can you check it once again. CAST("- Purchase Receipt Line Details"."Creation Date Line" AS DATE) < CAST("Purchase Order Schedule Detail"."Need…

Also a question on the formula, Isn't the SUM aggregation missing in the then clause for the Early Receipt Amount? CASE WHEN CAST("- Purchase Receipt Line Details"."Creation Date Line" AS DATE) < CAST("Purchase Order Schedule Detail"."Need By Date" AS DATE)-"Additional Schedule Information"."Early Receipt Tolerance Days"…

Hi Palak, Can you paste the error here as well to understand the issue better.

Hi @JITHU JOSE , I am not sure on the exact column which can help you identify the requisition lines which were approved. But one way could be if you check all the values of Approved date (LAST_APPROVAL_DATE) at requisition line level .Assuming that LAST_APPROVAL_DATE column value will be null for the lines not yet…

Good to know @JITHU JOSE . Thanks.

Hi @JITHU JOSE , If we apply the 'by' function (at sales order level) along with the MAX it would give the max invoice data and creation date for a sales order. For ex: Avg(MAX(CAST("Fulfillment Line Detail Details"."Billing Transaction Date" AS DATE) by SALES_ORDER)- CAST("Fulfillment Lines - General Details"."Creation…

Hi @Abhinav Gaddipati , Got it, So you are trying to customize a BIP report template (rtf) that is why it shows the word doc. I initially thought you need to edit and OTBI Analysis that is why asked to simply edit it. For BIP rtf templates you would have to download the template and customize it using Template builder for…

Hi Abhinav, We can always edit the predefined reports and save them as new and create new dashboards around it for having a customized version of it. Are you not able to edit the Accounts Receivable Aging Report?