Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to check reference of Physical columns in OBIEE 12c reports
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
Answers
-
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:
0 -
The smart thing is to use Gianni's solution.
0
