Data Lineage objects removed from OBIA RPD

Question

Hi All -

I recently completed the steps to configure data lineage for OBIA, per: https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-8E9904B5-E498-40E7-88BB-6F36B309CF37.htm#BIASA24666.

The data lineage ETL completed successfully. However, I am encountering some errors when trying to view the dashboards. I opened an SR for this, and it looks look it is happening because the RPD has been "trimmed". I can see that the data lineage elements are no longer included in the current version of the RPD. And, I did confirm that these objects do appear in a very early version of the RPD:

We have made numerous changes/customizations since the RPD was trimmed. My question is how do we go about getting data lineage objects back into the current version of the RPD? MOS suggested that it may be possible to use the 'merge' method.

Please kindly offer any ideas on what is the best way to do this.

OBIA 11.1.1.10.1 (OBIEE 11.1.1.9.3) | DB/DW 12.1.0.2

Regards,

Charles

Charles M · Answer

Hi Gianni,

Thanks for the guidance on this. I would have preferred to go manually with this. But, after looking over the RPD I wasn't sure I could get it right this time. So, I decided to experiment a bit.

Here's what I did:

I went for a 3-way full merge. Basically, I got the original RPD, then made a copy of it. I took out all of the presentation layer objects, from the copy (e.g. modified version), that we don't need/use (we use only Financials and Procurement & Spend at this time). I kept everything else in the BMM and physical layer. My thinking here was that the presentation layer was using the most space anyhow ... and, what extra stuff remained in the other layers wouldn't hurt to just keep in place for now.

I used the original, modified, and current versions of the RPD for the merge. The downside for me with this process was that I still had to make a bunch of "decisions" on various objects. Mostly init blocks and application roles! There were several hundred of these ... maybe even more. I wasn't able to choose/highlight multiple items at once, so I ended up doing them one-at-a-time . I did take a while to finish that part. But, once I completed and uploaded the new RPD, I was able to view/use the data lineage dashboards.

Not sure this is the best approach. But, it did server it's purpose, which was to test the data lineage dashboards. This is only a Dev instance ... so, we may be re-visiting this approach in the future.

Regards,

Charles

Gianni Ceresa · Answer

Have fun

And come back to give a feedback on how it went and close the thread (or continue it if issues happen)

Charles M · Answer

Thanks very much, Gianni. I'll start working on this ...

Regards,

Charles