Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Extract Subject Area/Dimension/Fact name from OBIEE

Received Response
4
Views
2
Comments
user607025
user607025 Rank 1 - Community Starter
edited Aug 13, 2024 6:09PM in Oracle Analytics Cloud and Server

Hello Everyone,

I am new to OBIEE and given a task to get all the columns and names validated from users. Is there any way through which we can extract a list containing the Subject Area, Dimension name, column name and Tooltip from OBIEE  for all the visible dimensions/facts/columns.

Thanks in Advance and Merry Christmas!!

Regards

Harsh Dhawan

Answers

  • user607025
    user607025 Rank 1 - Community Starter

    I have got a python script which uses MetadataService, describeSubjectArea and describeTable. But now the problem is that it is also extracting hidden columns, which I don't need. Is there any way to exclude or identify the hidden columns?

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Did you try "Tools" > "Utilities" > "Repository Documentation" and save as CSV ?

    You then open your file, delete the columns you don't need (ideally you are only interested in the first 3) and remove duplicates (so it will take you 2 clicks in Excel).