Using Matrixes for Cross-Checking

1
Using Matrixes for Cross-Checking
2
Setting the Scene
The ER Diagrammer shows all Entities and
Relationships...
and the Function Hierarchy Diagrammer shows
all business functions...
but I want to see both Entities and Functions...
How about a matrix?
3
The Matrix Diagrammer

• A two-dimensional Repository object display tool
• Is not like ERD, PM, or DFD
• Can maintain definitions
• Shows CRUD matrixes and many others

4
Defining Both Matrix Axes

• Choose both object types for the horizontal and
  vertical axes
• Most of the primary access elements
• Some secondary access elements
• Choice of second object type depends on choice of
  first axis

5
New Matrix Dialog
Initial Appearance
Choose Row Type
Choose Column Type
6
Settings Dialog
7
Resulting Matrix
8
Defining What is Displayed

• Properties displayed per object type and
  intersection (cell)
• Filters to reduce number of axis elements
• Sort order of objects

9
Modifying Display
10
New View
11
Displaying Properties
Row - Business Functions Column - Entities
Intersection-FunctionEntity Usage
Properties
View Order Filter
Lines
LabelShort DefinitionMaster FunctionParent
FunctionAtomic?Elementary?FrequencyResponse
NeededIntention to AutomateApplication System
A
is null
D
Y
Resulting Pseudo-SQL
SELECT label, response_neededFROM
business_functionsWHERE master_function IS
NULLAND elementary? YORDER BY
short_definition, atomic? desc
12
Defining Filter Conditions

• Limited, SQL-like criteria
• , gt, lt, gt, lt, ltgt
• IS NULL, IS NOT NULL
• value1 and value2
• A, _MEM
• No ORs, only implicit ANDs
• No Not Like

13
Displaying a Third Axis
PRICE PA
Settings automatically shows Entities tab
14
Uses of a Matrix

• Data entry
• Completeness checking
• Design reporting
• Impact analysis
• Repository management
• Progress reporting

15
Saving the Matrix

• Changes to data are saved automatically in the
  Repository.
• Saving a matrix means saving the matrix settings.
• A matrix is automatically requeried when opened.
• Broadcast is available for axis elements.

16
Summary

• Matrix Diagrammer
• Display and compact reporting tool
• Used for verification and correction of entries
• Over 160 different matrixes
• Over 40 3D matrixes