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

When you define a holap data group and you have data sources that share
the same class variables in either a given subtable within an MDDB or
all the class variables for a table, then the data model will rack, or
join, the like tables or subtables so the data will be added together.

Due to the current way the data model searches the available class
variables for each data source, a problem arises if the total length of
the class variable names concatenated together is greater than 200.  The
class variable list that is searched gets truncated to 200 characters,
so the data model could see 2 data sources as having the same class
variables and rack them together, when only the first 200 characters of
the class variable names list are the same and they do not share all
the same variables in the full class list.

To circumvent, you would need to shorten your class variable names so
that the total length of all the class variables in a given MDDB
subtable or a SAS table will be no more than 200 characters.

A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#004934


A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#004934

Operating System and Release Information

A fix for Release 8.1 (TS1M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) for this issue is available at: