SKU to Format, Flavour, etc
I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3.
The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore in column I've got SKU - F3 - F2 - F1 - V2 - V1, etc etc.
The issue is that when creating grids for UX I can never drill down to a SKU level within the same grid as the SKUs are not childs of any of the other hierarchies as there is (for obvious reasons) no child rolling up to multiple parents. Further than that, properties would not act as hierarchies, therefore flat tables would not cut it as there wouldn't be any sub-totals or what so ever.
Therefore I can build grids for Format or for Flavour, but can 1) never drill down to SKU 2) never include both Format and Flavour in the same grid which would filter one another.
May I ask if anyone has faced such complex issue and there is a way to solve this?