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…

Thanks @Benjamin Arnulf-Oracle for sharing the rationale behind for this new arrangement. It is now making more sense now, AI Data Platform → Data + Analytics + AI together.

It is good to know that there is a self-service upgrade option for existing instances becomes available on January 23 and also beginning January 23, any new Oracle Fusion Data Intelligence instances will automatically use Oracle AI Database 26ai. Thanks @Bindu Goparaju-Oracle for the article. Appreciate it!

Please refer Support KM article - An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512. Hope it helps!

OTBI Agent delivery channels are limited to Email, Dashboard and Alert-based delivery and there is NO standard or supported capability to deliver OTBI analyses directly to an SFTP location via Agents. In contrast, BI Publisher does support SFTP / FTP delivery This difference is by design in the Fusion BI architecture: OTBI…

Please refer Support KM article - An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512. Hope it helps!

OTBI Agent delivery channels are limited to Email, Dashboard and Alert-based delivery and there is NO standard or supported capability to deliver OTBI analyses directly to an SFTP location via Agents. In contrast, BI Publisher does support SFTP / FTP delivery This difference is by design in the Fusion BI architecture: OTBI…

Please refer Support KM article - An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512. Hope it helps!

OTBI Agent delivery channels are limited to Email, Dashboard and Alert-based delivery and there is NO standard or supported capability to deliver OTBI analyses directly to an SFTP location via Agents. In contrast, BI Publisher does support SFTP / FTP delivery This difference is by design in the Fusion BI architecture: OTBI…

Please refer Support KM article - An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512. Hope it helps!

OTBI Agent delivery channels are limited to Email, Dashboard and Alert-based delivery and there is NO standard or supported capability to deliver OTBI analyses directly to an SFTP location via Agents. In contrast, BI Publisher does support SFTP / FTP delivery This difference is by design in the Fusion BI architecture: OTBI…

@Dave Chudzik , Thanks for sharing the update and providing the solution as well. Appreciate it.

@Garrick Pina , Welcome to the Oracle Analytics Community! Oracle Warehouse Management Cloud feature enables connection to Oracle Warehouse Management System (WMS) to bring business relevant WMS data and build data augmentations for Logistics use cases. It comes under Third Party Data Connectors and currently available as…

@Ram ANeni Please review these General guidelines when there is a need to get data from multiple subject areas using facts and confirming dimensions from all the subject areas. If all the required metrics and attributes for the report are available in a single subject area and fact, use that single subject area only and…

Thanks for sharing the workaround, liked this innovative approach.

I believe steps are already mentioned in the blog that I provided above, please refer following Semantic Model ExtensionsThis section shows how to use Semantic Model Extensions to create metrics based on the custom financial category. Log in to FAW with the Modeler role. For information on roles, see the Oracle Fusion Data…