Data Lineage in OBIEE 12.2.1.4.0 - Can this be automated ?

Question

Hello Experts,

We have installed OBIEE 12.2.1.4.0 on Linux server. We have about 90 dashboards used nationwide by different regional groups. Our current need is to design a data lineage solution that can serve us the technical development group to assess impact analysis whenever there is a change in the data warehouse. We tried one approach of extracting -  1. RPD Metadata (using Repository Documentation Utility) , 2. Generate a Catalog Report using Catalog Manager to get information about all analyses & dashboards

and then building a small model in the RPD using these 2 extracts are physical data sources. Though this approach works, it is a manual effort .

Is there a way this process can be automated through server-side scripts or any other mechanism, by which, any incremental changes to the ware house can be captured efficiently ?

Please help. Your advise/suggestion is much appreciated.

Regards

Rakesh

3822729 · Answer

Thanks for the additional information. I would still check out the link where you have the slides. Never know, on a good day that site might just be up

Gianni Ceresa · Answer

The site has some issues right now :s

I had to refresh 10 times having all different errors to see them again (so it isn't my fault  ).

A way more generic (without code and technical details) can be found at https://gianniceresa.com/2018/03/gdpr-analytics-challenge/  and https://gianniceresa.com/2018/04/gdpr-analytics-solution/ , but still the slides are more detailed on how things have been achieved.

3822729 · Answer

Hi Gianni, Thank you. I wanted to check out the slides but the link doesn't seem to work.