1. Administering and Working with Enterprise Profitability and Cost Management
  2. Creating and Managing Applications
  3. Managing Applications
  4. Managing Dimensions
  5. Best Practices When Designing Dimensions

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.