How to Track RPD Changes Over Time in OAS/OBIEE?

Gopi Mannava

Hi Community,

We are trying to track changes made in the RPD over time — for example:

• What changes were made yesterday, in the past 30 days, or at any point in history
• Which objects were added/modified/deleted
• Details of the changes (logical models, joins, presentation layer, etc.)
• Ideally who made the changes and when

I saw in the Oracle documentation that the Administration Tool can be integrated with a source control system by saving the RPD as MDS XML documents and then checking those into SCM (Git/SVN/etc.) so the SCM history can be used for tracking. The docs describe this under “Using a Source Control Management System for Repository Development”.

However:

1. Is this the only way or is there any other ways to track RPD changes over time?
2. Is there any built-in audit/change history feature in OAS/OBIEE that can show version history without external SCM?
3. Are there best practices for setting up and using SCM with RPD so we can easily answer questions like “what changed in the last month” or “what changed yesterday”?
4. Any examples of how people use RPD version tracking other than GIT( Don't want to install open source)?

Here’s the Oracle doc reference I found:
https://docs.oracle.com/middleware/12211/biee/BIEMG/GUID-2BB43D1D-896A-4252-B4F0-F11AF710F139.htm#scm_update_save_changes

Thanks in advance!

JohnW-Oracle

Hi @Gopi Mannava ,

It looks like you have found the correct method and documentation here: https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/manage-oracle-bi-repository-files.html#GUID-80CD085C-F2CC-498D-8C0A-3428921FC2A6

You can Compare Repositories Using the Compare Dialog but this does not help over a 30 day period of time.

Maybe someone else can add to the 30 day part of the question.

As far as a best practice, RPDs should be saved with a timestamp in the name.

Regards,

John