Previous section   

Key Values

This section describes how DeepSee generates KEY values for level members.

Key Values

DeepSee generates KEY values as follows. Note that these values are case-sensitive, unlike all other items in MDX.
Scenario Format of KEY value Example Member Name* Corresponding KEY Value
Null member
<null>
None
<null>
All member
*
All Patient Addresses
*
Member of a level that uses the HourNumber time function Integer that represents the hour number
2
2
Member of a level that uses the DayMonthYear time function Integer that represents the date in $HOROLOG format
Dec 27 2004
59896
Member of a level that uses the DayNumber time function Integer that represents the day number
21
21
Member of a level that uses the WeekNumber time function Integer that represents the day number
6
6
Member of a level that uses the MonthNumber time function Integer that represents the month number
July
7
Member of a level that uses the WeekYear time function String in the form YYYYMWW
2012W06
2012W06
Member of a level that uses the MonthYear time function Integer in the form YYYYMM
July 2010
201007
Member of a level that uses the QuarterNumber time function Integer that represents the quarter number
Q3
3
Member of a level that uses the QuarterYear time function Integer in the form YYYYQQ
Q4 2010
201004
Member of a level that uses the Year time function Four-digit integer that represents the year number
2009
2009
Member of a level that uses the Decade time function Four-digit integer that represents the year number, followed by
s
1990s
1990s
Member of a computed dimension Member name, followed by a colon, followed by the SQL SELECT statement that retrieves the values
member 1
shown after this table***
Other scenarios Source value of the member (which is also used as the member name by default)**
Juniper
Juniper
Sorenson, Violet
169
*For levels in time dimensions, this column shows their default display names. Depending on how the level is defined, the member names might be different. See Defining DeepSee Models.
**In a well-defined cube, each member key is unique. See “Defining Member Keys and Names Appropriately” in Defining DeepSee Models.
***The key for a member of a computed dimension might be as follows:
&[member 1:select ID from DeepSee_Model_PatientsCube.Fact WHERE MxAge<50 AND DxHomeCity->PxName='Elm Heights']
You can use the PROPERTIES function to find the value of the KEY property or any other property of a member.
Previous section