Attribute view information from HANA metadata tables

[Former Member]

I have a requirement to create documentation for Attribute, Analytical and Calcualtion view column names and labels in Excel. I was able find meta data tables for Analytical and calculation views but not Attribute views. I was wondering if anyone know about these tables.

I know there is auto documentaion but it is too much pain to cut and paste into Excel

For example following are queries to get information for Analytical and calculation views

-- To get attribute information from calculation view
select CUBE_NAME, DIMENSION_NAME, DIMENSION_CAPTION
from "_SYS_BI"."BIMC_DIMENSIONS"

-- To get information on measures for anallytical and calculation views
select cube_name, measure_name, measure_caption
from "_SYS_BI"."BIMC_MEASURES"

Thanks

Bo

[sagarjoshi · Accepted solution]

I have seen that table _SYS_BI.BIMC_PROPERTIES has the column name and captions for all kinds of views (including measures of Analytic/Calc views).  You can check for DESCRIPTION column here and filter for property_type = 1