During the lunch today, we were discussing about the possibility to handle variable depth hierarchy within a data warehouse.

This didn’t seem to be really obvious. The depth of a dimension is usually fixed in a data warehouse.
After some googling, one of us found “Help for Hierarchies“.

This seems to be a solution for depth variable hierarchies. Something I should try once in a while.