Categories
- All Categories
- Oracle Analytics Learning Hub
- 27 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 235 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Subject area, folder name, column name list for the Oracle Business Intelligence 11.1.1.7.170418
We would like to create a list that shows Subject area name, folder name, and column name in Oracle Business Intelligence 11.1.1.7.170418.
Can you please advise if you have created a list that contains the items mentioned above.
Thanks.
Answers
-
You open your RPD with the Administration Tool, you go in Tools > Utilities... and select "Repository Documentation".
In the CSV you get the first 3 columns are: Subject Area, Presentation Table, Presentation Column
Just take those and remove duplicates and you have your list.
0 -
Gianni,
Do you have a query to generate a list for the Subject area, folder name, column name in the Oracle Business Intelligence 11.1.1.7.170418 instead of using the Admin tool.
0 -
The RPD isn't in a database, so if by "query" you expected a SQL query the answer is simple: not doable.
You can still get things by querying the BI server and running the following query:
call NQSQueryMetadataObjects('objectId', '', '', '', 'false', '', '');
replace objectId with:
4004 for subject areas
4008 for presentation tables
4010 for presentation columns
I would highly discourage this approach if you aren't 100% sure about what this calls do and how this work in OBIEE.
0 -
Can you pull the tool tip for the columns using the Admin tool ?
0 -
Sorry but what are you looking for exactly? Because the question keep changing. If you know exactly what you look for, just ask that directly.
0 -
We are looking for a way to pull the tool tips that appear when you hover over the presentation columns for each presentation column grouped by presentation table for each subject area.
Sorry for not making the question clear enough at the initial question.
Thank you.
0 -
Isn't that the description of the presentation column?
5th column of the "Repository Documentation" CSV file.
0 -
Thanks a lot for the information, you answered all our questions.
0 -
Good to hear. So could you close the thread and mark if required? This will help others having similar questions to find useful information.
Right now it's still This question is Not Answered.
0 -
Thanks again.
0
