Grouping Columns
You can include two or more Columns in the same Business Area Hierarchy level by using the Group With Previous flag. For example, you could define the following Business Area Hierarchy:
The example above shows a three-level hierarchy. Investigator ID and Investigator Name are both in the top level, which makes sense because they are alternate values for the same type of information. Patient is the middle level and Gender is the bottom level. In a visualization, users can drill down from the investigator by either name or ID, or view them both, to all patients for whom a particular investigator is responsible, to an investigator's male patients or the same investigator's female patients.
To define a Business Area Hierarchy:
Example 10-1 Business Area Hierarchy Column Grouping
Order number | Column | Group With Previous? |
---|---|---|
1 |
Investigator ID |
— |
2 |
Investigator Name |
Yes |
3 |
Patient |
— |
4 |
Gender |
— |
Parent topic: Defining Business Area Hierarchies