Problem Note 35795: Query results might be incomplete when a hierarchy has only two members in a level and one member is the ragged hierarchy indicator
 |  |  |  |  |
The results of an OLAP query might be incomplete if a hierarchy contains only two members in a level and one of the two members is used as the ragged hierarchy indicator. For example, a level in a hierarchy with the following two members is likely to return an incomplete result, if the value "ragged" is used to indicate a ragged hierarchy in the cube definition.
Member1 ragged
One possible workaround is to add an additional member to the level. For example, you might add another record to the detail or fact and dimension tables. The goal is to have at least three members per level when a ragged hierarchy is present.
Select 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 TS2M0 | 9.2 TS2M2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.2 TS2M2 | ||
| HP-UX IPF | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| OpenVMS on HP Integrity | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
A fix for this issue for Base SAS 9.21 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A01.html#35795| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2009-09-09 12:43:23 |
| Date Created: | 2009-05-04 17:37:20 |