Schema Details(Attributes,Metrics)

Lists attributes and metrics by repository, schema, and dimension to which each attribute or metric belongs.


select "L2METRIC",
"OBJECT_TYPE",
"LX_LOCATION",
"FOLDER_NAME",
"OBJECT_DESCRIPTION",
"REPOSITORY_NAME",
"OBJECT_NAME"
from (SELECT DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME, ODS_IMA_ELEMENT.ELEMENT_NAME AS FOLDER_NAME, ( SELECT EA.ELMNT_ATTR_VALUE FROM IMA_ELMNT_ATTR EA WHERE EA.CLASS_ATTR_NAME = 'infa_type' AND EA.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID ) AS OBJECT_TYPE , ODS_IMA_CHILD_ELEMENT.ELEMENT_NAME AS OBJECT_NAME, ( SELECT EA.ELMNT_ATTR_VALUE FROM IMA_ELMNT_ATTR EA WHERE EA.CLASS_ATTR_NAME = 'infa_description' AND EA.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID ) AS OBJECT_DESCRIPTION , ( SELECT EA.ELMNT_ATTR_VALUE FROM IMA_ELMNT_ATTR EA WHERE EA.CLASS_ATTR_NAME IN ('definition', 'Select') AND EA.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID ) AS L2METRIC , ODS_IMA_CHILD_ELEMENT.NAME_PATH as LX_LOCATION FROM IMA_ELMNT_ASSOC ODS_IMA_CHILD_ELMNT_ASSOC, IMA_ELEMENT ODS_IMA_CHILD_ELEMENT, IMA_ELEMENT ODS_IMA_ELEMENT, IMA_ELMNT_ATTR ODS_IMA_CHILD_ELMNT_ATTR, IMA_ELMNT_ASSOC ODS_IMA_ELMNT_ASSOC, IMA_ELEMENT ODS_IMA_PARENT_ELEMENT WHERE (ODS_IMA_CHILD_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_CHILD_ELEMENT. ELEMENT_UID AND ODS_IMA_CHILD_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND ODS_IMA_CHILD_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID AND ODS_IMA_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND ODS_IMA_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_PARENT_ELEMENT.ELEMENT_UID) AND (ODS_IMA_PARENT_ELEMENT.PRODUCT_TYPE = 'Business Intelligence' AND ODS_IMA_ELEMENT.CLASS_TYPE IN ('Folder', 'Folder,Dimension', 'Dimension') AND ODS_IMA_CHILD_ELEMENT.CLASS_TYPE IN ('Attribute', 'Measure') AND ODS_IMA_CHILD_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND ODS_IMA_ELEMENT.DELETED_FLAG = 'N' )) "query"
order by "REPOSITORY_NAME", "FOLDER_NAME", "OBJECT_TYPE", "OBJECT_NAME", "OBJECT_DESCRIPTION", "L2METRIC"