There are 18 Dimensions that can be used to filter data. This section briefly explains each Dimension and gives an example. See Dimension for a full description of each Dimension. Square brackets are optional around Member names, but are mandatory if the Member name contains a space, period, comma, or semi-colon.
Cube
Cb#GolfStream
The specific Cube being referenced.
Entity
E#Houston
The specific Entity being referenced.
Parent
P#Texas
The Parent of the Entity being referenced. This is important because Entities can be rolled up into multiple hierarchies.
Consolidation
C#Local
The specific Member of the Consolidation Dimension being referenced.
Scenario
S#Actual
The specific Scenario being referenced.
Time
T#2012Q1
Specific time period in focus. There are several selections available relative in nature to certain boundaries like the time period set in the POV, the selected Workflow time period, or the Global time period. More of these constants are explained in the Member Script Constants section later in this document.
T#POV
This returns the current period of the selected year in the Cube POV.
T#W1
This returns the first week of the selected year in the Cube POV (this only applies to weekly applications).
T#M1
This returns the first month of the selected year in the Cube POV.
T#Q1
This returns the first quarter of the selected year in the Cube POV.
T#H1
This returns the first half of the selected year in the Cube POV.
View
V#YTD
The specific view of the requested information.
Account
A#60000
The specific Account being referenced.
Flow
F#BegBal
Specific Flow Member being referenced. There is a dedicated Flow Dimension.
Origin
O#Import
The Origin of the data being referenced and then deciding if it was imported, entered as a Journal, or entered into a Form.
UD1 to UD8
U2#[Fairway Woods] or U3#TotalRegions
Specific Members from the eight User Defined Dimensions are being referenced. If all eight of these Dimensions are not being used, they still need to be qualified in the POV, in a Cube View, or in the Member Script to get a proper intersection. Each User Defined Dimension has a Member called None or the reserved word All that can be used (e.g. U5#All) in some areas of the product such as Intercompany Reporting settings.
