Two dimensions where not all cross joined combinations are needed
i have a list of divisions and a list of products. The divisions are defined by customer type and not by product, so not all divisions sell all products, but there is a lot of overlap. We would want to be able to show sales by division, and also sales by product.
The easy thing would be to have two unrelated lists, but the issue with that is the vast majority of combinations will always be blank. Also a division FC would want to see only those products relevant for his division, and not some giant list.
Illustrative example is below, but there would be a lot more “missing” products.
Create a concatenated hierarchy with L1 being Divisions and L2 being Products and have the list built from the actual data or transactional data (course 305: Hierarchy Management). L2 will be a numbered list with the Display Name property being list formatted to the Product Flat list.
I can see how this approach will let me get a hierarchy will only have the required items, and that the numbered list with display names will get around the duplication of names. I am not sure how this will allow me to show a breakdown of sales by product. Even though the products will have the same name, they won't really be the same under the hood will they?
I haven't looked at the 305 training yet, but I will do.