How to check reference of Physical columns in OBIEE 12c reports

Question

Hi All,

I am new to OBIEE .. Can anyone help me with the below question:

How can I find the reports that has reference of a particular physical column or presentation column in obiee?

Is there any way to find the report names ..

Please guide..

Thanks,

Anumita

[Deleted User] · Answer

The smart thing is to use Gianni's solution.

Gianni Ceresa · Answer

There are various answers to that kind of question.

Out of the box you can cover part of the needs by using Catalog Manager reports to find out which analysis (they aren't reports but analysis, a report is a BI Publisher report) reference directly which presentation column.

In the Admintool you can generate a CSV file with the mappings of the RPD (the 3 layers) which include most of things.

These 2 put together can give you answers.

It's important to keep in mind that they miss some cases etc.

You could also script things to have a proper data lineage:

https://gianniceresa.com/2018/03/gdpr-analytics-challenge/

https://gianniceresa.com/2018/04/gdpr-analytics-solution/