Dimension Tables

Each dimension hierarchy has two tables:

• Runtime Table: Dim_PC_{name}
• Model Management Table: Dim_MM_{name}

Naming Convention

• {name} is the dimension name for the main hierarchy, or {dimension name}_{hierarchy name} for alternate hierarchies.
• Spaces are replaced with underscores (_).
• The system prevents naming conflicts (e.g., "Cost Center" vs. "Center" hierarchy of "Cost").

Common Fields

Dimension tables typically include:

Field	Description
Key	Unique integer identifier for the member
Name	Unique string name for the member
Caption	Display name (multi-language support)
Tag	Optional label or category for the member
ParentKey	Key of the parent member (for hierarchies)
SortOrder	Integer for custom sorting within siblings
BaseMemberKey	Key of the base member (for alternate hierarchies)
Storage	Storage type or method for the member
IsLeaf	Indicates if the member is a leaf node
Path	Sort path for natural ordering
PathStr	String representation of the path
p_*	Custom property fields for the dimension

Dimension Specific Properties

Dimension	Properties
Account	KpiType BowtieMetric TimeBalance Recurring DebitCredit
Scenario	ScenarioType StartPeriod EndPeriod Status
Stage	StandardStageId StandardStageName SalesStage LastSalesStage LastStage BenchmarkKpi
Time	StartDate EndDate ActualPeriod
Entity	LocalCurrency