Problem Note 47974: A data integrity issue might occur if the NWAY is not compacted when you build a SAS® OLAP cube that uses a star schema
 |  |  |  |  |
When a star schema is used as an input type when building a cube, the NWAY is not always compacted. When the NWAY is not compacted, the wrong measures are returned if the NWAY is used to satisfy a query.
When the issue does occur, there is no indication that an error has occurred. The only way to identify the issue is by manually validating query results. Data discrepancies should be easily identifiable.
If the issue does occur, a workaround is available. When you build the cube for the first time, withhold at least one record. Then perform an incremental update that loads the withheld record or records. When you perform these tasks, the measures are summarized correctly, and the cube displays the correct values when queried.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | z/OS | 9.2 TS2M3 | 9.4 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | |||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | |||
| Microsoft® Windows® for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 9.2 TS2M3 | |||
| Windows 7 Enterprise 32 bit | 9.2 TS2M3 | |||
| Windows 7 Enterprise x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 9.2 TS2M3 | |||
| Windows 7 Home Premium x64 | 9.2 TS2M3 | |||
| Windows 7 Professional 32 bit | 9.2 TS2M3 | |||
| Windows 7 Professional x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 9.2 TS2M3 | |||
| Windows 7 Ultimate x64 | 9.2 TS2M3 | |||
| Windows Vista | 9.2 TS2M3 | |||
| Windows Vista for x64 | 9.2 TS2M3 | |||
| 64-bit Enabled AIX | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.2 TS2M3 | 9.4 TS1M0 | ||
| HP-UX IPF | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Linux | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Linux for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| OpenVMS on HP Integrity | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||