SAS Note SN-001199

From: tsdlist@UNX.SAS.COM
Date: Wed Nov 10 1999 - 10:05:37 EST


>>>>>>>> SAS Notes -- Copyright (c) 1991 - 1999 by SAS Institute Inc. <<<<<<<<

SN-001199 *** ALERT NOTE *** PRODUCT: WAREHOUSE

TITLE: Invalid results from Warehouse Administrator generated OLAP code

KEYS: WAREHOUSE ADMINISTRATOR OLAP MERGE UPDATE INVALID RESULTS WA SAS/WA
       SUMMARY MISSING CLASS TABLE SQL JOIN _TYPE_ TYPE ON

    You may get incorrect results when using SAS/Warehouse Administrator to
    perform a merge/update of an OLAP table that has multiple crossings.
    Extraneous records with missing values occur in the final table of the
    merge/update. The number of extraneous records may increase if there
    are missing class values in the input table. This problem does not
    affect OLAP MDDB's or OLAP tables that contain only single crossings.
    The cause of the problem is a missing _TYPE_ column in the ON clause for
    the SQL join that is generated to perform the merge/upate.

    To circumvent this problem, modify the SAS/Warehouse Administrator
    generated code and add the _TYPE_ column to the ON clause for the SQL
    join that performs the merge/update of the OLAP table.

+------REPORTED------+ +---FIXED---+
SYSTEM RELEASE LEVEL RELEASE LEVEL

AIX/R 8.00 M0 .
DigitUnx 8.00 M0 .
HP800 8.00 M0 .
OS/2 8.00 M0 .
Solaris 8.00 M0 .
WIN/NT 8.00 M0 .
Win98 8.00 M0 .
Win95 8.00 M0 .



This archive was generated by hypermail 2b29 : Mon Jan 10 2000 - 10:10:20 EST