Attributes and Metrics

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


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


select "DIMENSION_NAME",
"OBJECT_NAME",
"LX_LOCATION",
"REPOSITORY_NAME",
"OBJECT_TYPE",
"OBJECT_DESCRIPTION"
from (SELECT DISTINCT ODS_IMA_ELEMENT.REPOSITORY_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_ELEMENT.ELEMENT_NAME as DIMENSION_NAME, 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 , 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 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_ELEMENT.PRODUCT_TYPE = 'Business Intelligence' AND ODS_IMA_ELEMENT.CLASS_TYPE IN ('Dimension', 'Folder,Dimension') AND ODS_IMA_ELEMENT.DELETED_FLAG = 'N' AND ODS_IMA_CHILD_ELEMENT.CLASS_TYPE IN ('Attribute', 'Measure') AND ODS_IMA_CHILD_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' )) "query"
where "REPOSITORY_NAME" in ('<Repository_Name>')
order by "REPOSITORY_NAME", "OBJECT_TYPE", "DIMENSION_NAME", "OBJECT_NAME"

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*