Usage Note 40407: Understanding how SAS® Web Report Studio exports formats for measures and dimensions
When building a cube, you can specify a format for a measure. For example, you might specify a format of COMMA20.0 for a measure. You can also specify a format for a dimension by using the FORMAT_STRING property. For example, you might specify a format of PERCENTN10.1 for a dimension. However, when you export data from SAS Web Report Studio to Microsoft Excel, the format of the measure (COMMA20.0) is honored but the format of the dimension (PERCENTN10.1) is not.
Operating System and Release Information
SAS System | SAS Web Report Studio | Windows Vista | 4.2 | | 9.2 TS2M0 | |
Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
64-bit Enabled AIX | 4.2 | | 9.2 TS2M0 | |
64-bit Enabled Solaris | 4.2 | | 9.2 TS2M0 | |
HP-UX IPF | 4.2 | | 9.2 TS2M0 | |
Linux for x64 | 4.2 | | 9.2 TS2M0 | |
Solaris for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
z/OS | 4.2 | | 9.2 TS2M0 | |
*
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.
Date Modified: | 2010-08-05 11:06:13 |
Date Created: | 2010-07-21 15:00:01 |