• Print |
• E-mail  |
• Bookmark

Originally the MDX Properties function only returned the formatted value
of a property. Only returning the formatted value is not always desired.
The value of a property can be either numeric or character depending on
the property type.

The updated syntax for the Properties function is:

   member.Properties("String Expression", <TRUE | FALSE>)

If the new parameter for showing raw data is set to TRUE then the
Properties function will return the raw value for the property instead
of the formatted value. If the new parameter is set to FALSE, the
formatted string property is returned. The default for this parameter is
FALSE.

An example for sorting date values using the new properties function is:

   with  member [Measures].[mycalc] as
      '[product].currentmember.properties(""date"")'
   select
       non empty {crossjoin({[Time].[all time].children},
       {[measures].[mycalc]})} on columns,
       non empty order({[product].[sku].members},
       [product].currentmember.properties("date", TRUE),BDESC)
        properties [product].[sku].[date] on rows
   from myolapcube


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014355

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014355

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :