Lists all associations in a specified package. Associations identify the relationship between classes in a meta-model.

select “ORIGINATOR_NAME”,
“FROM_CLASS_NAME”,
“ASSOCIATION_NAME”,
“FROM_CARDINALITY”,
“MODIFIED_ON”,
“ASSOCIATION_DESC”,
“TO_CARDINALITY”,
“PACKAGE_NAME”,
“TO_CLASS_NAME”
from (SELECT DISTINCT MMR_ASSOC_PACKAGE.ORIGINATOR_NAME, MMR_ASSOC_PACKAGE.PACKAGE_NAME, MMR_IMA_ASSOCIATION.ASSOCIATION_NAME, MMR_IMA_ASSOCIATION.ASSOCIATION_DESC, MMR_FROM_CLASS.CLASS_NAME AS FROM_CLASS_NAME, MMR_IMA_ASSOCIATION.FROM_CARDINALITY, MMR_TO_CLASS.CLASS_NAME AS TO_CLASS_NAME, MMR_IMA_ASSOCIATION.TO_CARDINALITY, CONVERT(VARCHAR,MMR_IMA_ASSOCIATION.MODIFIED_ON,23) AS MODIFIED_ON FROM IMA_ASSOCIATION MMR_IMA_ASSOCIATION, IMA_CLASS MMR_TO_CLASS, IMA_PACKAGE MMR_ASSOC_PACKAGE, IMA_CLASS MMR_FROM_CLASS WHERE (MMR_IMA_ASSOCIATION.TO_CLASS_UID = MMR_TO_CLASS.CLASS_UID AND MMR_IMA_ASSOCIATION.PACKAGE_UID = MMR_ASSOC_PACKAGE.PACKAGE_UID AND MMR_IMA_ASSOCIATION.FROM_CLASS_UID = MMR_FROM_CLASS.CLASS_UID)) “query”
where “ORIGINATOR_NAME” in (‘<Originator_Name>’) and “PACKAGE_NAME” in (‘<Package_Name>’)
order by “ORIGINATOR_NAME”, “PACKAGE_NAME”, “ASSOCIATION_NAME”, “ASSOCIATION_DESC”, “FROM_CLASS_NAME”, “FROM_CARDINALITY”, “TO_CLASS_NAME”, “TO_CARDINALITY”, “MODIFIED_ON”

Displays all associations for the specified From Class. This report displays all classes associated with the specified From Class.

select “TO_PACKAGE_NAME”,
“PACKAGE_NAME”,
“FROM_PACKAGE_NAME”,
“ASSOCIATION_NAME”,
“FROM_CARDINALITY”,
“TO_CLASS_NAME”,
“FROM_CLASS_NAME”,
“ORIGINATOR_NAME”,
“TO_CARDINALITY”,
“MODIFIED_ON”
from (SELECT DISTINCT MMR_ASSOC_PACKAGE.ORIGINATOR_NAME, MMR_ASSOC_PACKAGE.PACKAGE_NAME, MMR_FROM_CLASS.CLASS_NAME AS FROM_CLASS_NAME, MMR_FROM_CLASS.PACKAGE_NAME FROM_PACKAGE_NAME, MMR_IMA_ASSOCIATION.ASSOCIATION_NAME, MMR_IMA_ASSOCIATION.FROM_CARDINALITY, MMR_TO_CLASS.CLASS_NAME as TO_CLASS_NAME, MMR_TO_CLASS.PACKAGE_NAME AS TO_PACKAGE_NAME, MMR_IMA_ASSOCIATION.TO_CARDINALITY, CONVERT(VARCHAR,MMR_IMA_ASSOCIATION.MODIFIED_ON,23) AS MODIFIED_ON FROM IMA_ASSOCIATION MMR_IMA_ASSOCIATION, IMA_CLASS MMR_TO_CLASS, IMA_PACKAGE MMR_ASSOC_PACKAGE, IMA_CLASS MMR_FROM_CLASS WHERE (MMR_IMA_ASSOCIATION.TO_CLASS_UID = MMR_TO_CLASS.CLASS_UID AND MMR_IMA_ASSOCIATION.PACKAGE_UID = MMR_ASSOC_PACKAGE.PACKAGE_UID AND MMR_IMA_ASSOCIATION.FROM_CLASS_UID = MMR_FROM_CLASS.CLASS_UID)) “query”
where “ORIGINATOR_NAME” in (‘<Originator_Name>’) and “PACKAGE_NAME” in (‘<Package_Name>’) and “FROM_CLASS_NAME” in (‘<Class_Name>’)
order by “ORIGINATOR_NAME”, “PACKAGE_NAME”, “ASSOCIATION_NAME”, “FROM_PACKAGE_NAME”, “FROM_CLASS_NAME”

Displays all attributes of the specified class, including its inherited attributes from parent classes.

select “CLASS_NAME”,
“ORIGINATOR_NAME”,
“CLS_ATTR_DEFAULT_VALUE”,
“EDITABLE_FLAG”,
“CLASS_ATTR_NAME”,
“PRNT_CLASS_NAME”,
“PACKAGE_NAME”
from (SELECT DISTINCT MMR_IMA_CLASS.ORIGINATOR_NAME, MMR_IMA_CLASS.PACKAGE_NAME, MMR_IMA_CLASS.CLASS_NAME, MMR_IMA_CLASS_ATTR.PRNT_CLASS_NAME, MMR_IMA_CLASS_ATTR.CLASS_ATTR_NAME, MMR_IMA_CLASS_ATTR.CLS_ATTR_DEFAULT_VALUE, MMR_IMA_CLASS_ATTR.EDITABLE_FLAG FROM IMA_CLASS MMR_IMA_CLASS, IMA_CLASS_ATTR MMR_IMA_CLASS_ATTR WHERE (MMR_IMA_CLASS.CLASS_UID = MMR_IMA_CLASS_ATTR.CLASS_UID)) “query”
where “ORIGINATOR_NAME” in (‘<Originator_Name>’) and “PACKAGE_NAME” in (‘<Package_Name>’) and “CLASS_NAME” in (‘<Class_Name>’)
order by “ORIGINATOR_NAME”, “PACKAGE_NAME”, “CLASS_NAME”, “PRNT_CLASS_NAME”, “CLASS_ATTR_NAME”

The Classes Exploration analytic workflow displays all classes in the metamodel and enables you to explore its contents, such as its attributes and packages.

select “EXTENDABLE_FLAG”,
“PACKAGE_NAME”,
“CLASS_DESC”,
“ORIGINATOR_NAME”,
“MODIFIED_ON”,
“CLASS_NAME”
from (SELECT DISTINCT MMR_IMA_CLASS.ORIGINATOR_NAME, MMR_IMA_CLASS.PACKAGE_NAME, MMR_IMA_CLASS.ORIGINATOR_ID, MMR_IMA_CLASS.PACKAGE_ID, MMR_IMA_CLASS.CLASS_ID, MMR_IMA_CLASS.CLASS_NAME, MMR_IMA_CLASS.CLASS_DESC, CONVERT(VARCHAR,MMR_IMA_CLASS.MODIFIED_ON,23) as MODIFIED_ON, MMR_IMA_CLASS.EXTENDABLE_FLAG FROM IMA_CLASS MMR_IMA_CLASS) “query”
where “ORIGINATOR_NAME” in (‘<Originator_Name>’) and “PACKAGE_NAME” in (‘<Package_Name>’) and “CLASS_NAME” in (‘<Class_Name>’)
order by “ORIGINATOR_NAME”, “PACKAGE_NAME”, “CLASS_NAME”, “CLASS_DESC”, “MODIFIED_ON”, “EXTENDABLE_FLAG”

select “EXTENDABLE_FLAG”,
“PACKAGE_NAME”,
“CLASS_DESC”,
“ORIGINATOR_NAME”,
“MODIFIED_ON”,
“CLASS_NAME”
from (SELECT DISTINCT MMR_IMA_CLASS.ORIGINATOR_NAME, MMR_IMA_CLASS.PACKAGE_NAME, MMR_IMA_CLASS.ORIGINATOR_ID, MMR_IMA_CLASS.PACKAGE_ID, MMR_IMA_CLASS.CLASS_ID, MMR_IMA_CLASS.CLASS_NAME, MMR_IMA_CLASS.CLASS_DESC, CONVERT(VARCHAR,MMR_IMA_CLASS.MODIFIED_ON,23) as MODIFIED_ON, MMR_IMA_CLASS.EXTENDABLE_FLAG FROM IMA_CLASS MMR_IMA_CLASS) “query”
where “ORIGINATOR_NAME” in (‘<Originator_Name>’) and “PACKAGE_NAME” in (‘<Package_Name>’) and “CLASS_NAME” in (‘<Class_Name>’)
order by “ORIGINATOR_NAME”, “PACKAGE_NAME”, “CLASS_NAME”, “CLASS_DESC”, “MODIFIED_ON”, “EXTENDABLE_FLAG”

The Repository Type Exploration analytic workflow displays all repository types in the metamodel and enables you to explore its contents, such as its packages and repository instances.

select “ORIGINATOR_NAME”,
“REPO_TYPE_NAME”,
“REPO_TYPE_DESC”,
“PRODUCT_TYPE”
from (SELECT DISTINCT MMR_IMA_REPO_TYPE.PRODUCT_TYPE, MMR_IMA_ORIGINATOR.ORIGINATOR_NAME, MMR_IMA_REPO_TYPE.REPO_TYPE_ID, MMR_IMA_ORIGINATOR.ORIGINATOR_ID, MMR_IMA_REPO_TYPE.REPO_TYPE_NAME, MMR_IMA_REPO_TYPE.REPO_TYPE_DESC FROM IMA_REPO_TYPE MMR_IMA_REPO_TYPE, IMA_REPO_PACKAGE MMR_IMA_REPO_PACKAGE, IMA_PACKAGE MMR_IMA_PACKAGE, IMA_ORIGINATOR MMR_IMA_ORIGINATOR WHERE (MMR_IMA_REPO_PACKAGE.REPO_TYPE_UID = MMR_IMA_REPO_TYPE.REPO_TYPE_UID AND MMR_IMA_REPO_PACKAGE.PACKAGE_UID = MMR_IMA_PACKAGE.PACKAGE_UID AND MMR_IMA_PACKAGE.ORIGINATOR_UID = MMR_IMA_ORIGINATOR.ORIGINATOR_UID)) “query”
order by “PRODUCT_TYPE”, “ORIGINATOR_NAME”, “REPO_TYPE_NAME”