I like to make my reports and data models as simple as possible. This is to ensure the users follow the path you have created and dont stray.
My model is basically four tables
- Product - this is at product level and includes the product category (parent of product).
- Sales - by Month and product
- Budget - by Month and Product Category
- Calendar - by Month
When I create my data model I would like to see
I also want to join Product to both the sales and budget tables!
This is the underlying data
This is what the customers want
What I really want is One product dimension that joins to Sales and Budget at different levels. Is this possible