Extract Subject Area/Dimension/Fact name from OBIEE

Question

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

Gianni Ceresa · Answer

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

user607025 · Answer

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