Need Report/Utility to find the BIP Data Models having reference to a table or column

Kumar K

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Tesco Stores Ltd

Description (Required):

Need Report/Utility to find the list of BIP Data Models that are using particular table or column for impact analysis

Use Case and Business Need (Required):

We have high volume of BIP Reports and is very difficult to do impact analysis in case of any column or table reference change is required.

Can we have a Report/Utility to find the BIP Data Models having reference to any table or column like it was given to identify BIP reports accessing DATA_CACHE column( Doc ID 2692905.1 ) ?

"Run diagnostic report “BIP Datamodels with DataCache references”

Enhancement Request / Service Request:

SR 3-26257283691 : Need Report/Utility to find the BIP Data Models having reference to any table or column

PrJohns-Oracle

This would be helpful when Cloud deprecates a table and a new table is needed and we need to update current reports for clients.

User_6UWFD

Great idea!

User_Q0BFB

This is a great idea!

User_NCIZE

Great idea!