DeepSee MDX Reference
Key Values
[Back] 
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

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.