Cell Properties (MDX)

Cell properties are defining some meta-information attached to measures and calculated members/measures.

Description

In MDX a cell can define not only a value (e.g., string, numerical value) but a list of predefined properties.

Two steps are needed :

1) Define the property in a calculated member and/or regular measure :

Note that cell property definitions are not limited to MDX literals (e.g., string, numerical value). Indeed any valid MDX expression can be used as well:

        WITH MEMBER [value] AS [Measures].[Amount],
                                   BACK_COLOR = IIF( currentCellValue() < 0, RGB(255,0,0), RGB(0,0,0) )
        

VALUE, FORMATTED_VALUE, CELL_ORDINAL properties are already defined and it's not possible to override the default behavior.

2) Define the list of cell properties to be calculated in the MDX query :

After defining a property the cell property value can be retrieved by using 'CELL PROPERTIES' statement in the mdx statement :

        SELECT [MyAxe] on 0
        FROM [MyCube]
        CELL PROPERTIES VALUE, FORMATTED_VALUE, FORMAT, FONT_NAME
        

If CELL PROPERTIES is not defined VALUE, FORMATTED_VALUE, CELL_ORDINAL properties will be retrieved. Note that CELL_ORDINAL is always included even though it is not in the list of requested cell properties.

Standard MDX properties:

        ACTION_TYPE              :
        ASSOCIATED_MEASURE_GROUP : defines the measure group a calculated measure is attached to.
        BACK_COLOR               :
        CAPTION                  : defines the caption of a calculated member.
        CELL_ORDINAL *           :
        DISPLAY_FOLDER           : defines the location (path) of a calculated measure.
        FONT_FLAGS               :
        FONT_NAME                :
        FONT_SIZE                :
        FORE_COLOR               :
        FORMAT_STRING            : controls how cell values are formatted.
        FORMATTED_VALUE *        :
        LANGUAGE                 : controls how cell formatted values are localized.
        UPDATEABLE               :
        NON_EMPTY_BEHAVIOR       : defines the non empty behavior of a calculated measure.
        SOLVE_ORDER              : controls the order of evaluation of calculated members.
        VALUE *                  :
        VISIBLE                  : controls the visibility of a calculated member.
        

icCube specific properties:

        CLASSNAME      : defines HML/CSS properties to be used for cell rendering.
        REQUEST_CACHED : controls how tuple values are cached.
        STYLE          : defines HML/CSS properties to be used for cell rendering.
        

Note, FORMAT is not supported by icCube (use FORMAT_STRING instead).

(*) Those properties are read only, can not be defined.

See Also

Calculated Members

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.