I have a data table that seems to be a multi-dimensional table where some dimensions have sub-dimensions. I firstly loaded the one-level dimensions e.g. #, Division/ Sub-Gruop, Business Unit, Comment, Action into one table and then loaded and transposed the two-level dimensions in a separate table and linked them using Business Unit field.
I was wondering if there's a better way of doing this?
