8.1.1.2.2.1 Subject Area Glossary

Each Subject Area has a pre-defined glossary that provides essential documentation for users, helping them understand data structure and relationships.

  • List of all result entities included in the subject area
  • Entity granularity of each result entity based on the primary keys
  • Attribute name and detailed attribute description for all primary keys
  • Entity relationships that define relation of attributes with related dimension entity and the related attribute

The glossary helps users determine which attributes can be combined in a single visualization for meaningful insights. A single visualization should include attributes of similar granularities to avoid Cartesian join issues, which can lead to data misinterpretation.

For Example:

Attributes from Common Account Summary and Loan Account Summary can be used together in a single visualization.
  • End of Period Balance (EOP Bal) for loans should not be combined across Account Rating Details and Common Account Summary.
  • If an account has three credit ratings from different agencies, it will have three rows for the same account, repeating the EOP Bal value.
  • This could lead to the EOP Bal being aggregated incorrectly (e.g., tripled for a single account).
Subject Area Glossary can be accessed as below:
  1. Home -> Catalog -> Shared folders -> Subject Area Glossary

    Figure 8-14 Subject Area Glossary


    Subject Area Glossary