Problem Note 36746: SAS® datetime variables might generate incorrect results when used as the input column to supplied time hierarchies
The Dimension Designer in SAS® OLAP Cube Studio and SAS® Data Integration Studio provides the ability to create pre-defined time hierarchies based on a single column of input. Although this functionality works only with SAS date variables, the drop-down list for selecting the input column currently enables you to select a SAS datetime variable.
If you select a datetime variable, the cube will display either asterisks (***) or incorrect data. As a workaround, you can modify the formats that are used to define the hierarchy so that they use the appropriate datetime versions. For example, specify DTYEAR4. instead of YEAR4.
Operating System and Release Information
| SAS System | SAS OLAP Cube Studio | Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
*
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: | high |
| Topic: | Data Management ==> Data Sources ==> Cubes
|
| Date Modified: | 2009-08-11 14:10:40 |
| Date Created: | 2009-08-06 17:21:44 |
