Oracle Fusion BI Dashboard Development

@RahulTheAnalyst

I can do your job.. pls reach out- I already have the BI Publisher data models and reports built inside our Oracle Fusion Cloud instance; what I am missing is the finished dashboard. Here is what I need: • Build a new BI dashboard page that uses the existing reports as its data sources. • Display the reports as table format, i have 4 report, each report should be in 1 tab • Apply a clear colour scheme that distinguishes information by account type (for example, assets vs. liabilities) across every table and filter control. ( i will give further details on specific colors) • minimal changes in the sql query required

@BannaSA12

1. Data Definition and Integrity We will use Data Definition Language (DDL) commands in SQL (such as CREATE TABLE, ALTER TABLE, DROP TABLE) to accurately define the database schema. This includes specifying: Tables and Columns: Defining the structure of our data. Data Types: Ensuring data consistency (e.g., INT, VARCHAR, DATE). Constraints: Enforcing data integrity rules. Key constraints include: Primary Key: Uniquely identifies each row. Foreign Key: Establishes relationships between tables, ensuring referential integrity. NOT NULL: Prevents missing values in critical columns. UNIQUE: Ensures no duplicate values outside of the Primary Key. 2. Data Manipulation We will utilize Data Manipulation Language (DML) for all operations that interact with the actual data stored in the tables: SELECT: The core command for retrieving data based on specific criteria. We will use clauses like WHERE for filtering, JOIN for combining data from multiple tables, and aggregate functions (SUM, AVG, COUNT) for analysis. INSERT: Adding new records to a table. UPDATE: Modifying existing records. DELETE: Removing records from a table.

@dushyant317

I am an expert in all required project skills with 13 years of professional experience. I deliver high-quality, reliable work with attention to detail. My background includes completing similar projects successfully. I can start immediately and meet all deadlines. Looking forward to contributing to your project.

@bhaskarxrm

Hi there, I can build your OTBI dashboard page using the existing BI Publisher data models and reports already configured in your Oracle Fusion Cloud instance. Since your data layer is ready, I will focus on clean integration, minimal SQL adjustments, and a fully functional dashboard experience. I will create a new OTBI dashboard with four tabs—each tab displaying one of your reports in table format—ensuring that filters, prompts, and layout behave consistently across all tabs. Once you share the specific colour scheme, I’ll apply clear, unified color coding by account type (e.g., assets, liabilities, equity, etc.) to both table components and filter controls. This will provide strong visual distinction without compromising Oracle’s native UI performance. All work will be completed directly in your sandbox environment. I will confirm that every report loads without errors, filters respond correctly, and the design remains stable after refreshing or navigating between tabs. The final dashboard will be clean, intuitive, and fully aligned with Fusion/OTBI best practices. I can begin immediately and deliver quickly, with iterations based on your design feedback. Best Regards Bhasker