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

Using the SAS OLAP Server Monitor, a Metadata Administrator can view the
status of active users and open result sets for OLAP cubes on the SAS
OLAP Server.

Initially in SAS 9, the MDX String returned for specific user requests
was in the form of:

   WITH... SELECT... FROM... WHERE...

The display area that lists the "MDX String" column that holds the MDX
query string has no horizontal scrollbar. Therefore, longer MDX query
strings cannot be fully viewed and information like the active cube name
in the FROM clause is not always visible.

In most cases administrators need to at least be able to view the active
cube names to verify if a specific cube is in use or if it is available
for update. So to make this information more readily available for
administrators, the order of the MDX clauses within the MDX string has
been modified so that it is now in the form of:

   FROM... WHERE... WITH... SELECT...



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

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

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 :