Best Practices When Designing Dimensions
-
Use dynamic dimensions sparingly. They are slow to aggregate, which impacts both reporting and calculation speed. Stored dimensions are the best choice. See Hierarchy Types.
-
When creating a stored dimension, keep in mind that shared members are only allowed in the second hierarchy or later.
-
Understand how the top levels of dimensions impact usability. See Dimension Top Levels.
-
Allow for future dimension growth.
-
Do not overlook the need for intermediate step dimensions or data categorization dimensions.