Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Data Lineage in OBIEE 12.2.1.4.0

Received Response
1
Views
3
Comments
Rak_D
Rak_D Rank 1 - Community Starter
edited Aug 13, 2024 5:35PM in Oracle Analytics Forum

Hello Experts,

We have OBIEE 12.2.1.4.0 installed on RHEL 7.3. We are trying to achieve Data Lineage to track which DB column is used where (report/dashboard) and to also see the impact of DB column change.

Is there any utility that can be used to achieve this ?  Please advise.

Thank You.

Rakesh

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    If you look into SampleApp you find scripts and RPD / dashboards covering exactly that.

    There isn't in OBIEE itself a "single click" data lineage but you have all the elements to get the pieces you will need to connect together.

    On one side you need to get the presentation columns used by objects in your catalog and catalog manager can do it.

    On the other side you need to map these presentation columns back till a database physical column, for that the RPD documentation can help.

    You combine the 2 pieces and done.

    Or, as said, you look into the SampleApp VM and take the scripts from there.

  • Rak_D
    Rak_D Rank 1 - Community Starter

    Thanks Gianni. This information will definitely help.

    Regards

    Rakesh

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you feel like having some fun you can also find some hints on "data lineage" in https://gianniceresa.com/2018/04/gdpr-analytics-solution/

    It mainly point to a presentation which you find here: https://speakerdeck.com/gianniceresa/gdpr-and-you-the-nightmare-of-ba

    It has pieces of codes / methods to use etc.