List of Hierarchies

Lists the hierarchies in a schema


Click on the text to copy the query report to your clipboard.


select "REPOSITORY_NAME",
"LX_LOCATION",
"HIERARCHY_NAME",
"HIERARCHY_DESCRIPTION"
from (SELECT DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME as REPOSITORY_NAME, ODS_IMA_ELEMENT.ELEMENT_NAME as HIERARCHY_NAME , ( SELECT EA.ELMNT_ATTR_VALUE FROM IMA_ELMNT_ATTR EA WHERE EA.CLASS_ATTR_NAME = 'infa_description' AND EA.ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID ) as HIERARCHY_DESCRIPTION , ODS_IMA_ELEMENT.NAME_PATH as LX_LOCATION FROM IMA_ELEMENT ODS_IMA_ELEMENT, IMA_ELMNT_ATTR ODS_IMA_ELMNT_ATTR WHERE (ODS_IMA_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID) AND (ODS_IMA_ELEMENT.CLASS_TYPE = 'Hierarchy' AND ODS_IMA_ELEMENT.DELETED_FLAG = 'N' AND ODS_IMA_ELEMENT.PRODUCT_TYPE = 'Business Intelligence' AND ODS_IMA_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' )) "query"
order by "REPOSITORY_NAME", "HIERARCHY_NAME", "HIERARCHY_DESCRIPTION", "LX_LOCATION"