Hi @Ram ANeni , as per my understanding, this is expected in when mixing subject areas, When we add a column to Results, OTBI generates a logical outer join like query and Subject areas can coexist as long as there is a conformed dimension path. When we add a column to Filters, OTBI generates a constrained WHERE clause and…

@Sai Poorna, Welcome to the Oracle Analytics Community! This forum is about Oracle Analytics and related products. You will be better served if you can put your question in General Ledger & Intercompany — Cloud Customer Connect Thanks

@Oren Benjamin-Oracle , Welcome to the Oracle Analytics Community! Thanks for the question. Please refer oracle doc, this shows how to register and use Data Science models in analytics workflows - another step toward a more integrated platform. In terms of OCI Data Science adopting AIDP, hoping Oracle Product Team can…

@Alexandria Toothman-Oracle , Thanks for sharing the session with the community, appreciate it.

@Arun Kumar Bangalore , Welcome to the Oracle Analytics Community! You are correct those are not related to AP invoices. Please use this payable invoice view object that contains information about invoices such as invoice number, invoice date, invoice amount, supplier, currency and so on. There is one row for each invoice.…

@User_N6HIU , Welcome to the Oracle Analytics Community! Please try following steps and see if it works for you… Edit the Dashboard Remove the BI Publisher report Re- add the BI Publisher Report Do not use “Link” or “External Content” Save and reload dashboard

@User_N6HIU , Welcome to the Oracle Analytics community! Please try the solution listed in this support article. Hope it helps!

Please refer following support article https://support.oracle.com/support/?anchorId=&kmContentId=3020612 Hope it works!

@fusionenthu , as per my understanding, prune time does not need to match hourly frequency It must protect daily + retry + ingestion latency so with mixed schedules 1440 minutes is ideal Anything ≤ 240 minutes is unsafe for FDI + augmented PVOs. Hope it helps!

@James McBride You are always welcome to log an enhancement request and let Oracle product team review/comment on it.

@fusionenthu , Welcome to the Oracle Analytics Community! For any PVO that ends in ERROR, the “Last Extract Date” is not updated. As a result, the data for those errored PVOs will be re-extracted in the next successful run. Above error indicates that the OTBI / BI Server query timed out while extracting data for specific…

Best practice is to always activate Oracle Fusion Data Intelligence into your Oracle Fusion Cloud Applications account. Doing so saves you time, cost, and complexity when setting up your security integration between Oracle Fusion Data Intelligence and your Oracle Fusion Cloud Applications, as well as improved ongoing…

@User_7AIAG , Welcome to the Oracle Analytics Community! Each FDI environment is a separate OCI deployment, so you will incur OCI consumption costs for: Autonomous Data Warehouse Object Storage OCI Data Integration AI/ML services OCPUs So while there’s no extra FDI license, there is an additional OCI cost per environment.

@Sai Poorna , Welcome to the Oracle Analytics Community! This forum is about Oracle Analytics and related products. You will be better served if you can put your question in General Ledger & Intercompany — Cloud Customer Connect Thanks

Thanks @JimVT for updating this post. @Pritha , as suggested above, please start a new post with your questions. Thanks

There is no practical way to make an HTML BI Publisher report with ~700k rows perform well. As per my understanding, BI Publisher loads the entire XML data set into memory then applies grouping and calculations in the XSLT layer and then renders every row for HTML output and it is all going to be CPU and memory intensive.…

Please refer About Data Access through Security Assignments for more details. Hope it helps!

@James McBride , Welcome to the Oracle Analytics Community! As per my understanding, FDI does not use ERP role/BU security only by default, it uses FDI security contexts and assignments. It means each user must have the FDI data role + an assigned ledger and AP business unit value in FDI for data to populate. Just having…

You can try following … for-each-group for group header current-group() for details

@User_OJ8L8 , Welcome to the Oracle Analytics Community. It is an interesting requirement. As per my understanding, it might not be possible at BIP level because there is no “protect Word output” option. If possible, it could be done at the Microsoft Word template level, we might need to leverage Word document protection…