Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
