Adding hierarchies to your semantic data model
During your requirement gathering, you have collected your hierarchies, groups, and drill paths. This needs to be added to your semantic data model.
Review your requirements and find all the columns which are included in groupings, drill paths, or hierarchies.
How to do it...
Hierarchies, drills, and groupings are ways in which people consolidate information. The examples can include the following:
- Hierarchy: As a user, I expand country to see invoices by city
- Groupings: Show me all the invoice dollars by product
- Drill: From product category, I want to drill down to and see all the dollars via SKU
These are different ways in which business can articulate the need to group attributes at higher ...