Subject area, folder name, column name list for the Oracle Business Intelligence 11.1.1.7.170418

User_BE2B4

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.

Gianni Ceresa

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.

User_BE2B4

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.

Gianni Ceresa

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.

User_BE2B4

Can you pull the tool tip for the columns using the Admin tool ?

Gianni Ceresa

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.

User_BE2B4

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.

Gianni Ceresa

Isn't that the description of the presentation column?

5th column of the "Repository Documentation" CSV file.

User_BE2B4

Thanks a lot for the information, you answered  all our questions.

Gianni Ceresa

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.

User_BE2B4

Thanks again.