Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Data Lineage in OBIEE 12.2.1.4.0 - Can this be automated ?
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
Answers
-
Hi, if you look into Sample App (https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html ) you will find scripts and RPD + dashboards doing these things. The scripts will maybe not work out of the box for 12.2.1.4 (because they are from an older version, main change is the lightweight SSO enabled by default which is annoying for scripts).
For a different approach getting even more details out you can have a look at this slides: https://speakerdeck.com/gianniceresa/gdpr-and-you-the-nightmare-of-ba
Both can be fully scripted and automated.
0 -
Hi Gianni, Thank you. I wanted to check out the slides but the link doesn't seem to work.
0 -
The site has some issues right now
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.
0 -
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
0
