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.
Getting ready
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 ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
