8.1.2.2.1 Subject Area Glossary
Each subject area has it’s pre-defined glossary that documents below:
- List of all result entities included in the subject area
- Entity granularity of each result entity based on it’s 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
Subject Area Glossary is very useful for user to determine which attributes can be combined together in a single visualization to give meaningful data. A single visualization should include attributes of similar granularities, else the data may lead to Cartesian join issue.
For Example: All attributes from Common Account Summary and Loan Account Summary can be viewed in a single visualization. However, Value measures attributes like End of Period Balance (EOP Bal) for loans can’t be combined from Account Rating Details and Common Account Summary. As an example, if an account has 3 credit ratings from multiple rating agencies, it will have 3 rows for same account with 1 row for each account, and hence repeating EOP Bal in each row, which might lead to EOP balance being aggregated thrice for a single account. The only logical single visualization recommended in such cases is to view rating and account mapping, without including any measure attributes and without aggregating them.
Subject Area Glossary can be accessed as below:- Home -> Catalog -> Shared folders -> Subject Area Glossary
Figure 8-11 Subject Area Glossary
