...
The problem description starts with enumerating the hierarchies of dimensions categories used in the problem. Dimensions Categories are sorted from the finest grain to the larger grain.
...
Each
customer
belongs to acustomer_group
and an unrelatedcustomer_country
.Each
product
belongs to aproduct_family
which itself belongs to aproduct_group
.shipping_mode
is a dimension category without any hierarchical relation to any other dimensioncategory.
Code Block | ||
---|---|---|
| ||
hierarchies: - [customer, customer_group] - [customer, customer_country] - [product, product_family, product_group] - [shipping_mode] |
All the categories used as dimensions , in their correct hierarchies, are to be defined. They are used in the spaces definitionsin any space description must be present in the hierarchy list.
Note: MaybeSome times, from the end-user point of view, the customer group is hierarchical with the country: “wholesales/UK” is not the same group of customers as “wholesales/CZ” for instance. But if the customer group has the same name in both countries, like “wholesales”, it is not a hierarchy, it is a cartesian product. A hierarchy would be with the values “UK” and “CZ” for the countries and “wholesales-UK”, “wholesales-CZ”, “retail-CZ“ for the customer groups.