Data Lineage in OBIEE 12.2.1.4.0

Question

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

Gianni Ceresa · Answer

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.

Rak_D · Answer

Thanks Gianni. This information will definitely help.

Regards

Rakesh

Gianni Ceresa · Answer

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.