Usage Note 39901: SAS® OLAP Cube Studio evaluates the need for the VALIDVARNAME option starting in SAS® 9.2
 |  |  |  |
When building a cube in SAS 9.1 using SAS OLAP Cube Studio, the VALIDVARNAME=ANY option is always set even though it might not be needed. This behavior has been changed in SAS 9.2 for SAS OLAP Cube Studio. Specifically, the cube definition is now evaluated to determine whether the VALIDVARNAME=ANY option needs to be generated in the PROC OLAP code.
For SAS OLAP cubes, the VALIDVARNAME option is also used to determine the letter casing of the cube name in metadata and in the file system.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Cube Studio | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | |||
| Microsoft Windows XP Professional | 9.2 TS2M0 | |||
| Windows Vista | 9.2 TS2M0 | |||
| Windows Vista for x64 | 9.2 TS2M0 | |||
| Type: | Usage Note |
| Priority: | |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) Data Management ==> Data Sources ==> Cubes SAS Reference ==> System Options ==> VALIDVARNAME= |
| Date Modified: | 2010-06-17 09:57:13 |
| Date Created: | 2010-06-04 13:30:12 |