Aggr of an Aggr

[cjohnson]

Hi Everyone,

I don't think it can be done the way I am trying to do it (which is an aggr in an aggr), but you all have an idea for an alternative way?

So the premise is simple. I have finished goods and components (that make up the finished goods).

Let's say I have 3 finished goods:

1 - X Y Z

2 - X Y Z

3 - X Y G

Please note that finished good 1 and 2 have the same (makeup of) components. These are called a variant. So between those 3  finished goods - there are 2 variants (X Y Z and X Y G). I can't flag these variants in the script because we need to be able to select other attributes to determine what these variants are.

In the end, what I am trying to get is::

Dimension    Expression

1, 2                X Y Z

1                    X Y G

I can get it the other way around with a simple aggr function, but I need to be able to do it as a dimension (and not an expression).

So, what I'm looking for is something like below, but it's invalid:

aggr(F1,aggr(F2,F1))

I can't group these in the script because it needs to be dynamic. It can't be an expression because the real example is more complicated with the components being listed by another dimension.

It can't be done in the script really - unless I do a complicated combination of them all.

Does anyone have any thoughts or ideas on how to solve this?

[cjohnson]

I think I'm perhaps not explaining my intent clearly enough - but I'm not sure how else to better explain this concept. If anyone else understands what I'm trying to get across - please chime in.

The solution I'm looking for is as follows:

With everything cleared (based on my current example):

This indicates that there are 2 variants - X, Y Z and X, Y G. These first variant has 2 finished goods (1 and 2) - the second variant has one finished good (3). I think the piece missing here is the reason for wanting the finished goods as a dimension - it's because the variants can be grouped by other attributes (as shown above). So in this case I not only want to see the variants but I want to see the variant makeup (by F2Attribute).

With only Component "X" selected:

This is telling me something different. This is telling me that based on my selection of X I have 1 variant -- and all finished goods (1, 2, 3) share this variant...In this case the finished goods are how I want the data to be sliced.

I will try to think of other ways to explain my goal, but I'm not sure what else can provide. If anyone has any insight I would really appreciate your feedback.

I appreciate all the feedback from everyone!

Thanks!