dimension of a dimension

What do you mean by that?


Something like this:

All Customers, Firm A, <NULL>
All Customers, Firm B, <NULL>
All Customers, Firm C, <NULL>
All Customers, Customer 1, <NULL>
All Customers, Customer 12000, <NULL>
All Customers (by firm), Firm A, Customer 1
All Customers (by firm), Firm B, Customer NN

Since Customer 12000 isn't employed in a firm that is your customer she is
not contained in the parallel hierarchy. This would result in something like
this:

All Customers
|- Firm A
|- Firm B
|- Firm C
|- Customer 1
|- Customer 12000
All customers (by firm)
|-Firm A
|- Customer 1
...
|-Firm B
|-Customer NN

Maybe your Frontend supports something like this. Since there are two
All-levels you don't have double counts. The question arises how many
historical versions you want to keep.

Regards,

Jörg
 >> Stay informed about: dimension of a dimension