Problem Note 17839: Unexpected results may appear in SAS® Information Map Studio when an OLAP relative time filter range has been created for a date value
 |  |  |  |  |
When performing a query in SAS Information Map Studio, unexpected results may appear if the OLAP query includes a relative time filter range. This is the result of the filter actually being a range filter with fixed values, even though it was defined as a range filter with relative values.
The problem is most likely to occur if "The first period" and "The last period" have been selected for starting and ending periods for the Date Range selections. The "first" and "last" periods applied to the filter will be static date/time values from when the filter was created. For example, if the first value in the cube changes at some point after the filter is created, the filter will not begin on the new "first" value, but will always begin on the "first" value at the time of filter creation.
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Information Map Studio | Microsoft Windows XP Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows NT Workstation | 3.1 | 4.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
A fix for this issue for SAS Information Map Studio 3.1 is available at:
http://www.sas.com/techsup/download/hotfix/ims31.html#017839| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> Information map |
| Date Modified: | 2006-07-12 08:50:12 |
| Date Created: | 2006-06-08 15:28:16 |