Hi all, could you help me how best to structure a parallel hierarchy list that we need as part of our ongoing business analysis. Here's the construct that I'm looking at.
At the bottom level we have Clients that we need to be able to aggregate by different attributes. These attributes are:
Client: Client 1, Client 2..... Client 10
Geography: Geo 1, Geo 2
Model: Model 1, Model 2
Category: Category 1, Category 2, Category 3
Status: Status 1, Status 2
I thought about creating flat lists with all of the above, but the issue is that with multiple parents for the same item (i.e. Clients), I can't get auto aggregation at various levels. Would greatly appreciate if someone could advise on the best way to get this done.
We might need a little more information in order to help. A couple of questions:
does everything have to be in a hierarchy or list?
How are those attributes related to the clients?
can the clients span multiple categories, models, statuses, geographies?
Based off the information, I would create a composite list of what you know to be the standard with the attributes in line items in a SYS module, formatted as lists. Then, you can can do different types of Sums off those attributes to get the aggregations needed.