The OLAP Procedure

PROPERTY Statement

The PROPERTY statement assigns properties to specific levels within specified hierarchies.

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

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.

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
   ;

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.

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. [cautionend]

Default:

The column's label if it exists, otherwise the property name.

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.

Default:

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 only can be one map field for each SAS_SPATIAL_ID property. In addition, there can only be one SAS_SPATIAL_ID property per level. [cautionend]

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.

SAS_SPATIAL_ID

specifies the ESRI mapping properties for the cube levels that you are mapping to. The COLUMN, HIERARCHY, and LEVEL property options are included.

To associate the values in your OLAP data with the regions of an ESRI map, your cube must contain member properties whose values match the field values in the ESRI map service. For each level of a hierarchy that you want to use with the ESRI map component, you must define a member property named SAS_SPATIAL_ID to identify the map region. Here is an example:

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

Top of Page