The OLAP Procedure

PROPERTY Statement

The PROPERTY statement assigns properties to specific levels within specified hierarchies. Each level can have more than one property assigned to it by using multiple PROPERTY statements. Property names must match the name of a column in the input data source, or you must use the COLUMN= option to specify the column name.

Associate a Geographical Region with a Level

Example

Syntax

PROPERTY prop-name LEVEL=level-name <option(s)>;

Details

Required Arguments

prop-name: specifies a valid SAS name for the property. Usually this is the name of a column in the input data source. If it is not the name of a column, then you must include the COLUMN= option to specify the column name. For naming guidelines, see Naming Guidelines and Rules for the SAS OLAP Server .

LEVEL=level-name: specifies the name of the level that you are assigning the property to.

Options

CAPTION='string': specifies a maximum of 200 characters that can be used to create a meaningful description of the level. Third-party applications that report on cube data might display this description. If the caption includes blank spaces or special characters that are not permitted in a valid SAS name, then enclose the caption within quotation marks. The default value is the column's label if it exists; otherwise tit is he property name.

Note: Cubes that are built with captions that are longer than 200 characters cannot be fully registered in the SAS Metadata Repository. Captions will be truncated to 200 characters.

COLUMN=column-name: specifies the name of a column from the input data source. You must use this option if the column name is not the same as the property name.

DESC | DESCRIPTION='string': specifies any number of characters that can be used to create a meaningful description of the level. Third-party applications that report on cube data might display this description. If the description includes blank spaces or any characters that are not permitted in a valid SAS name, then enclose the text within quotation marks. The default is the value of the CAPTION= option if one exists; otherwise, the column's label.

ESRI_MAP_FIELD=MapFieldName: specifies the field of the map layer to be associated with the level. It must be a map field associated with the LEVEL statement MapLayerName. The OLAP property must be named "SAS_SPATIAL_ID" and must be a property of the level associated with the map layer. It must be associated with all hierarchies in the dimension. If the HIERARCHY= (or HIERARCHIES=) option is specified, all hierarchies in the dimension must be specified.

Note: There can be only one map field for each SAS_SPATIAL_ID property. In addition, there can be only one SAS_SPATIAL_ID property per level.

HIERARCHY=(hier-name ... hier-nameN): specifies the name of one or more hierarchies that contain the level. If you do not include the HIERARCHY option, then the property is automatically assigned to all occurrences of the level in all of the hierarchies in which it appears. Otherwise, the property is assigned to the level only in the specified hierarchies.

MLSID=n: is a positive integer identifier between 0 and MACINT (2147483647) that identifies the observation in the data set that contains the translated caption and description for the property. This identifier is expected in the MLSID column of the data set specified by DIMTABLECAPPREF=, DIMTABLELIBREF=, and the USER_DEFINED_TRANSLATIONS statement.

Note: For further information on MLS caption tables and MLSID, see USER_DEFINED_TRANSLATIONS Statement.

Associate a Geographical Region with a Level

To associate a geographical region with a level, create a property for that level named SAS_SPATIAL_ID. The spatial property provides field values that are recognized by the ESRI mapping service, as shown in the following example:

PROPERTY SAS_SPATIAL_ID 
LEVEL=Level2_ProvinceID 
HIERARCHY= (geography )
COLUMN=Level2_ProvinceID_Char  
CAPTION='SAS_SPATIAL_ID'

Example

In the following example, the COLUMN= option is used in the first two PROPERTY statements because the column name is different from the property name. In this way, the property named Population can be assigned to both the country level and the state level in the geo hierarchy. The level state has two properties: Population and West_of_Miss.

property Population
   column=p_country
   hierarchy=geo
   level=country
   ;
property Population
   column=p_state
   hierarchy=geo
   level=state
   ;
property West_of_Miss
   hierarchy=geo
   level=state
   ;