Cube Configuration

UD Member Properties

This guide covers the member-level properties for the User-Defined (UD) dimensions — UD1 through UD8. UD members also support the common properties shared by all dimension types (identifiers, descriptions, security, display order) and the same FormulaType, AllowInput, and IsConsolidated properties as Account members — see Account Member Properties for those shared definitions. For Flow member properties (SwitchSign, SwitchType, FlowProcessingType), see Flow Member Properties. For how dimensions are created, named, and assigned to cubes, see Dimension Library and Inheritance.

User-Defined (UD) Dimension Member Properties

UD members are configured at Application > Cube > Dimensions > UD1–UD8 Dimensions. The Member Properties tab contains properties that mirror the Account dimension's core settings.

Standard Properties

UD members support the same FormulaType, AllowInput, and IsConsolidated properties as Account members. The behavior is identical — see Account Member Properties for details.

UD Default Mappings (UD2Default–UD8Default)

Each UD member can define default mappings to other UD dimensions. When data is entered for a UD1 member, the engine checks whether that member has a UD2Default, UD3Default, etc. defined, and uses those defaults to fill in the unspecified UD coordinates. This reduces the number of intersections users need to explicitly select during data entry.

Attribute Members (IsAttributeMember)

A UD member can be defined as an attribute member by enabling the IsAttributeMember property. Attribute members are read-only derived values — they do not store data directly but derive their values from properties of other members (Name, Description, Text fields).
Key rules for attribute members:
  • Set AllowInput = False to prevent inadvertent use in data integration
  • Data intersections are not loaded directly to attribute members — results are derived from referenced properties
  • Attribute members act like other dimension members for reporting — they can appear in Cube Views as rows or columns
  • The Account, Flow, and UD dimensions support attribute members for calc-on-the-fly aggregations at parent members

RelatedDimensionType for Consolidation

The RelatedDimensionType property on a UD attribute member controls consolidation behavior:
  • When RelatedDimensionType = Entity, the attribute calculates on the fly at base-level entities without adding to the Data Unit. At parent entities, the values are stored and do add to the Data Unit.
  • For stored dimension types (Entity, Scenario), attribute results are not automatically summarized or consolidated to parent members. If parent-level results are needed, run a consolidation or aggregation. Set IsConsolidated = True on the attribute member for this.
⚠️Warning
UD attribute members can impact application performance, particularly consolidation time. The dynamic generation of attribute member data intersections adds to the final Data Unit size. Include the potential intersections from attribute members in your Data Unit sizing analysis. As a guideline, evaluate performance impact when the number of attribute members exceeds a handful.

UD Constraints (VaryByCubeType)

UD members support the same constraint system as Account members. Constraints restrict which intersections are valid for a UD member per cube type. Invalid intersections receive no aggregation and no input.

Related Content