Forum Discussion
Problem with Dimension and Datamodel
CatB (Sex) is independent, you can normalize that out. For the other categories can you guarantee that each element only appears once in the hierarchy tree? Or are there duplicates?
Hello,
Thanks for the answer 🙂 Well, category A can have different items from category C (see line 3 and 4 in the screenshot). These, in turn, are different items from category D and E. Basically, the individual items result from E + D + C = A. However, there should be no duplicates per line (line 8). These will then be deleted. And yes, actually it's like a family tree where category a is the root and then it branches further down. It is then counted how many items from the lower nodes lead to which node above it.
So I despair because the amount of combinations then becomes 1000 (A) x 1-2 lines (C) x 1-10 lines (D) x 1-10 lines (E) with about 1000 lines. Quite apart from the fact that I can't connect the dimensions because there is no 1:n connection. So: Questions over questions.....
