Oracle Analytics Cloud and Server Idea Lab

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

Visualise Lineage of Data Flows, Datasets & Workbooks

Needs Votes
41
Views
4
Comments

Wondering if it'd be possible to visualise data flows, datasets & workbooks that are connected to one another. I would click to any data flow, workbook or dataset & automatically see a visual aid that allows me to see where it sits in the bigger picture similar to how you see linages in the Semantic Model feature. For example, a workbook may run on a dataset A, & that dataset was the output of a data flow which required two other datasets to build upon it & so on & so forth.

We have soooo many data flows & datasets, it's difficult to monitor & manage, & difficult to remember which data sets, workbook & data flows rely on which ones, & ensure we do not mistakenly delete datasets or data flows that would then impact reporting down the road. But its also good to see which datasets or data flows are not utilised in reporting of which may need to be reviewed & then possibly removed.

I know you can click on a data flow & see the Sources/Targets but you have to do that manually for each data flow.

22
22 votes

Needs Votes · Last Updated

Comments

  • Joshua Snitzer
    Joshua Snitzer Rank 2 - Community Beginner
    edited Oct 1, 2024 7:43PM

    This would be fantastic. We have a ton of dataflows, datasets, workbooks, dashboards, and it is very difficult (even impossible!) to get a birds-eye-view of how data is used in OAC.
    We have enterprise governance requirements about how OAC is used that cannot be met with the current product.

  • Erik AE
    Erik AE Rank 2 - Community Beginner
    edited Oct 8, 2024 4:46AM

    This is important for us as we cannot provide suitable governance documentation around our OAC product. Even if this cannot be deployed, having a report that you can export from OAC that outlines all items in OAC & how they interconnect would be a good start. This is proving to be critical the more people are using OAC & the harder it is to monitor everything.

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    I vote for it. It is hard to manage.

  • John Tibbutt
    John Tibbutt Rank 1 - Community Starter
    edited Jan 9, 2025 1:24PM

    +1 this would be really useful