Oracle Analytics Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Enable Sankey Diagrams with Support for Multiple Values in Oracle DV

Submitted
6
Views
2
Comments
Anh Tran-Oracle
Anh Tran-Oracle Rank 1 - Community Starter
in Oracle Analytics Idea Lab

Background:
It would be highly valuable to display financial diagrams, such as Profit & Loss flows or tab walks, directly within Oracle DV. Currently, the Sankey diagram only supports a single value field. To create a P&L, users must export their data to Excel to manually structure it with “source,” “target,” and “value” columns (for example, mapping inflows and outflows), and then re-import it to DV for visualization. This workflow is inefficient, and introduces risks around data protection and version control, since manual exports can expose sensitive financial information.

Current Example Use Case:
• A finance analyst wants to build a live, interactive P&L or tab walk diagram based on the year-to-date information.
• Data is exported to Excel, where source, target, and value columns are manually created. Values must be manually calculated.
• The modified file is then imported into DV as a dataset to build the Sankey diagram.
• This increases both manual effort and risk to sensitive financial data.

Proposed Enhancement:

  1. Enable Multiple Value Fields in Sankey Diagrams:
    • Users can map multiple fields (e.g., revenues and multiple expense types) directly in the DV Sankey setup.
    • The system natively interprets expenses as outflows and automatically subtracts them from their related inflows for the visualization.
  2. Intuitive Source/Target Mapping and Flow Designation:
    • Enhance the Sankey UI so users can easily designate which columns represent positive flows and which represent negative flows (expenses/costs).
2
Up
2 votes

Submitted · Last Updated

Comments

  • RVohra
    RVohra Mod

    While waiting for your idea to be reviewed by Product Team, I would suggest you read this blog, Oracle Analytics team has done tremendous job by adding new AI profiling capabilities for insight generation, and an expanded list of data modelling sources supported, It has many new features to explore.

    Hope it helps!

  • Sushant Mishra
    Sushant Mishra Rank 6 - Analytics & AI Lead
    edited Jan 8, 2026 2:10AM

    Going through this use case, you can leverage the Data Flow feature in Oracle Analytics to manipulate and join tables, create calculated fields, and prepare the data without the need to download it outside OAC.

    In the below example, I have created datasets directly from Autonomous Database and linked them using Data Flows, which helps reduce manual handling and improves data governance compared to exporting data to Excel.

    That said, while Data Flows help with data preparation, having native support in the Sankey visualization for multiple value fields and clearer inflow/outflow handling would further simplify financial use cases like P&L or tab-walk diagrams.

    Hope this helps.

    image.png