• I would go with the second option because it allows you more flexibility as you don't depend on traversing the hierarchy using the same route each time. I'm assuming that Style, Article and Size are independent from each other and you can have the same size within different articles and styles. Using a hierarchy, each instance of size will be different and it will create more problems when you try to get a report by size.

    This is unless the 3 dimensions are small enough for a junk dimension to make sense.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2