Problem Note 6766: Cannot extract InfoCubes from SAS/ACCESS to SAP BW which have compound
characteristics where reference character of compound in SID table does
not match InfoObject name
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
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to SAP BW | Microsoft Windows 95/98 | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | 8.2 TS2M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2002-04-22 16:24:28 |
| Date Created: | 2002-01-25 08:49:11 |