• Print |
• E-mail  |
• Bookmark

SAP BW uses a snowflake schema presentation which consists of a fact
table, dimension tables, surrogate ID (SID) tables, text tables and
master data tables.  SAS/ACCESS to SAP BW uses the key fields in the
SID tables of the snowflake schema to retrieve the text and master data
information for the star schema presentation in SAS.  Compound
characteristics are those required to uniquely identify the master
data and text data.

Sometimes the reference character [CHABASNM] of a compound
characteristic does not match its InfoObject name.  When you perform a
view table or an extraction of an InfoCube which contains compound
characteristics with mismatched reference characters, you receive the
following error:

 ERROR: Table <name of table> with variable <name of variable> is not
 available in Fields Metadata table


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

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

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#006766

Operating System and Release Information

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

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: