• Sorry for the delay Micheal, as I mentioned I only included a condensed list of fields, other I can think of which are included are order description for example. The most important attributed for the business are associated dates.

    However, since you ask......there are several attributes on a order which have a one-to-one relationship such as status, final outcome etc. etc. Now we are going off topic a little but originally I included these fields on the order dimension. The guys in the team wanted this separated out into separate dimensions so now we have several attributes which are snowflaked and will be 'flattened' in views to the cube.