Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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
1
Views
2
Comments
user607025
user607025 Rank 1 - Community Starter
edited Aug 13, 2024 6:09PM in Oracle Analytics Forum

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).