Problem Note 11390: User-defined formats are ignored on OLAP cube measures at run-time
If you have associated user-defined formats on measures within an OLAP cube, the formats will be ignored when data is returned from a query. The unformatted values will be returned instead. No warning or error will generated in the log.
To display the formatted values, you can use an IIF function:
iif([Measures].[Value] or [Measures].[Value] = 0,
PUT([Measures].[Value],"myfmt."),
"NO VALUE")
|
Any user-defined format referenced in this way must be accessible by the SAS® OLAP Server and stored in a permanent format catalog.
Beginning with SAS 9.2, most user-defined formats are supported. However, if a user-defined format references other formats, such as the ones in the following example, the formats will be ignored by the OLAP measure. The previous MDX expression is an appropriate alternative if you are using this type of format.
PROC FORMAT LIB=OLAPSAMP;
VALUE hwgroup
low -< 0.5 = [PERCENT8.2]
0.50 - high = [8.2];
RUN;
|
Operating System and Release Information
| SAS System | SAS OLAP Server | Linux | 9.1 TS1M0 | 9.3 TS1M0 |
| HP-UX IPF | 9.1 TS1M0 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
| Microsoft Windows 2000 Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | 9.3 TS1M0 |
| z/OS | 9.1 TS1M0 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.3 TS1M0 |
| OpenVMS Alpha | 9.1 TS1M0 | 9.3 TS1M0 |
| Tru64 UNIX | 9.1 TS1M0 | 9.3 TS1M0 |
*
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: | medium |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
System Administration ==> Servers ==> OLAP
|
| Date Modified: | 2008-01-17 17:53:15 |
| Date Created: | 2003-12-02 12:55:40 |
