Problem Note 20028: Empty drillthrough result when format width for a column is too small
When drilling through to the detail data for a SAS OLAP cube, you might
unexpectedly receive an empty drillthrough table result. This can happen
if you have a format specified whose width is not wide enough to contain
the formatted value. This is incorrect because it gives the impression
that no data exists.
PROC PRINT generates this note when it encounters a data set with this
type of format:
NOTE: At least one W.D format was too small for the number to be
printed. The decimal may be shifted by the "BEST" format.
If you review the SAS log from the cube build, you see the following
note that would give a clue as to the format being the cause of the
problem.
NOTE: Formatting exceptions occurred during data classification for
variable <varname>. The format width was probably too small for one
or more of the values.
Operating System and Release Information
SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M3 | 9.2 |
64-bit Enabled AIX | 9.1 TS1M3 | 9.2 |
OpenVMS Alpha | 9.1 TS1M3 | 9.2 |
64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 |
HP-UX IPF | 9.1 TS1M3 | 9.2 |
Linux on Itanium | 9.1 TS1M3 | 9.2 |
Linux | 9.1 TS1M3 | 9.2 |
z/OS | 9.1 TS1M3 | 9.2 |
64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 |
Microsoft Windows NT Workstation | 9.1 TS1M3 | 9.2 |
Microsoft Windows XP Professional | 9.1 TS1M3 | 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: | 2007-05-01 09:59:35 |
Date Created: | 2007-04-20 16:34:21 |