• Print |
• E-mail  |
• Bookmark

If a calculated member is created on a hierarchy other than the default,
the Allmembers MDX function may return an error if used with the
dimension name only. For example, if a calculated member is defined as
follows:

   with member [Dimension].[Hierarchy2].[All Hierarchy2].[Test] as
      'Test'

then the following select statement will give an error stating that the
tuple specification is invalid for the ALLMEMBERS function.

   select [Dimension].allmembers on columns from [Cube]

The workaround is to specify the dimension and hierarchy name as
follows:

   select [Dimension].[Hierarchy2].allmembers on columns from [Cube]


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#014457

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#014457

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 :