Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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 :