Oracle AI and Analytics

Govardhana Gurumal

All,

I don't see there is a pre built data lieneage which gives more spectrum of solutions or answers for the BI leadership.

1.How many reports each users are owner and what is its path

2.Is these insights are sourced by Subject areas , data sets , Local Subject areas etc

3.Which content duty roles are associated to each insights

Regards,

Guru

Clare Murtagh

Hi @Govardhana Gurumal - yes you’re right, there's nothing pre-built that answers all three in one place, but you can get most of the way there by stitching a couple of things together:

• 1 & 2 - Enable Usage Tracking in the FDI Console. The usage tracking tables log the catalog path, user and subject area for every query run, so you can build a workbook on top showing which reports each user is hitting and what they're sourced from (subject area, dataset etc). It shows who runs content rather than who owns it, so for ownership you'll still need to check the catalog object properties or use the OAC catalog REST APIs.
• 3 - For duty roles, the FDI reference guide for each pillar (e.g. HCM Analytics) lists the job/duty roles and data security needed for each subject area. Map those against the subject areas from point 2 and you've got your security lineage.

Not perfect, but it gives BI leadership a decent picture. Probably worth an Idea Lab post for a proper lineage view too