Please review the below doc: Creating Analyses and Dashboards in Oracle Transactional Business Intelligence

Please review the below doc:

Please check the below links: Solution Brief: Analytics and Reporting for Oracle Fusion Cloud Applications - Oracle Analytics Overview of Oracle Fusion Financials Reports and Analytics Work Area

@George Mattar :Please mark this thread as "Accepted answer", So that it will be useful for others.

Steps to Restrict Tile Visibility by Security Role: Use the Page Integration Wizard When creating the tile, use the Page Integration Wizard to generate a security code.This security code can be linked to specific roles. 2. Assign the Tile to a Specific Role Navigate to Structure > Tools > Configuration.Locate the tile and…

Please mark this thread as "Accepted answer", So that it will be useful for others.

Steps to Restrict Tile Visibility by Security Role: Use the Page Integration Wizard When creating the tile, use the Page Integration Wizard to generate a security code. This security code can be linked to specific roles. 2. Assign the Tile to a Specific Role Navigate to Structure > Tools > Configuration. Locate the tile…

Steps to Restrict Tile Visibility by Security Role: Use the Page Integration Wizard When creating the tile, use the Page Integration Wizard to generate a security code. This security code can be linked to specific roles. 2. Assign the Tile to a Specific Role Navigate to Structure > Tools > Configuration. Locate the tile…

Try the below: Enable Fixed Headers with Scrolling Content Go to View Properties in your analysis. Select Fixed headers with scrolling content and click OK. 2. Use a Custom CSS Approach If you're embedding OTBI reports in a dashboard, you can apply custom CSS to enforce column widths.

Check the below doc: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/resize-rows-and-columns-views.html#GUID-2462B793-E4BD-4D10-BB54-4D36FDF43991

Try the below: Session Dependency Issue Some OTBI agents may be tied to an active session. Check if the agent is configured to run asynchronously rather than requiring an active user session. Authentication & Security Settings If recent security updates were applied, they might be preventing agents from running in the…

Try Modifying the Pivot Table Options: Right-click on the pivot table and select PivotTable Options. Under the Layout & Format tab, check For empty cells, show: and leave it blank. This prevents empty rows from displaying.

Try the below options: Use MIN() and MAX() Functions Use ROW_NUMBER() for First and Last Entries You can use ROW_NUMBER() to rank entries and fetch the first and last rows: sql WITH AbsenceData AS ( SELECT absence_start_date, absence_end_date, ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY absence_start_date ASC) AS…

Try the below options: Use MIN() and MAX() Functions Use ROW_NUMBER() for First and Last Entries You can use ROW_NUMBER() to rank entries and fetch the first and last rows: sql WITH AbsenceData AS ( SELECT absence_start_date, absence_end_date, ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY absence_start_date ASC) AS…

Try the below: Modify the Bursting Query You can pass report parameters explicitly in the bursting query by defining them in the data model and referencing them in the SQL query. It allows you to pass parameters to the bursting query using :parameter_name syntax. 2. Embed Parameters in the Dataset Since bursting removes…

If non-administrator users are having trouble accessing OTBI reports, it could be due to role-based permissions or folder access settings. Here are a few things to check: BI Consumer Role – Ensure that users have the BI Consumer Role, which grants them Read/Traverse access to OTBI reports. BI Author Role – If users need to…

To check the history of report executions: BI Publisher Audit – Fusion Cloud retains BI Publisher audit data for 90 days, which includes details of manual report executions. OTBI Audit – Execution data is available for six months, and older data is purged weekly. Please review the below KM notes: How To Configure And Use…

You can create a custom app tile for an OTBI dashboard to make it more accessible for recruiters. Please review the below doc: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/create-your-first-dashboard.html…

Please review the below KM notes and follow to create report from cross Subject Areas: Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1) Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI - KB89403

Oracle Analytics Publisher in Oracle Fusion Apps Cloud is designed to access data from Fusion Apps transactional database. JDBC/JNDI connections to external databases aren't supported. Refer https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/data-source-connections.html