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. Also, no warning or error will generated in the log.
If the intention is to replace the missing values with another value, one workaround could be to create calculated members for the problematic measures like:
with member measures.newval as
'iif(measures.val = NULL, "NO VALUE", PUT(measures.val,"best."))'
|
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M0 | 9.2 |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.2 |
| OpenVMS Alpha | 9.1 TS1M0 | 9.2 |
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.2 |
| HP-UX IPF | 9.1 TS1M0 | 9.2 |
| Linux | 9.1 TS1M0 | 9.2 |
| z/OS | 9.1 TS1M0 | 9.2 |
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.2 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.2 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.2 |
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.2 |
| Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.2 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.2 |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.2 |
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.2 |
*
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 |
