Dimensions

Dimensions are fundamental components in data modeling, representing one aspect of a business such as accounts, entities, or time. They organize and structure data for accurate storage, retrieval, and analysis. By defining dimensions appropriately, organizations ensure consistency, integrity, and efficiency in managing master data across models.

Dimension Types

Dimensions are classified based on their purpose. Common types include:

• Account: Maintains chart of accounts and financial metrics, supporting structures like profit and loss statements or balance sheets.

• Entity: Represents organizational units such as companies or business entities.

• Time: Captures time-related data for planning and reporting (e.g., monthly, quarterly, yearly).

• Version: Differentiates scenarios like actuals, budgets, forecasts, and plans.

• Custom: Allows flexibility for user-defined dimensions to meet unique business needs.

Other specialized types include Flow, Currency, Scenario, Dataset, and Notes, each serving specific modeling requirements.

Members and Hierarchies

Each dimension consists of members, which are individual data elements (e.g., an account code or a product name). Members can be organized into hierarchies to reflect relationships such as parent-child structures. Hierarchies enable efficient reporting and analysis by grouping related members logically.

Member Properties and Attributes

Dimension members have properties that define their characteristics, such as text descriptions, numeric values, dates, or links to other records. Common property types include:

• Text, Number, Date, Percentage

• Single-select and Multi-select options

• Parent Dimension for hierarchy reporting

• Security-related attributes like Team for role-based access

These properties ensure data integrity and provide flexibility for customization.

Standard vs Custom Dimensions

• Standard Dimensions: Mandatory for all models, such as Time and Account, ensuring consistency across the enterprise.

• Custom Dimensions: User-defined to address specific business requirements, offering adaptability for unique planning or reporting needs.