SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 20028: Empty drillthrough result when format width for a column is too small

DetailsHotfixAboutRate It
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

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS OLAP ServerTru64 UNIX9.1 TS1M39.2
64-bit Enabled AIX9.1 TS1M39.2
OpenVMS Alpha9.1 TS1M39.2
64-bit Enabled HP-UX9.1 TS1M39.2
HP-UX IPF9.1 TS1M39.2
Linux on Itanium9.1 TS1M39.2
Linux9.1 TS1M39.2
z/OS9.1 TS1M39.2
64-bit Enabled Solaris9.1 TS1M39.2
Microsoft Windows 2000 Advanced Server9.1 TS1M39.2
Microsoft Windows 2000 Datacenter Server9.1 TS1M39.2
Microsoft Windows 2000 Professional9.1 TS1M39.2
Microsoft Windows 2000 Server9.1 TS1M39.2
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M39.2
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M39.2
Microsoft Windows Server 2003 Standard Edition9.1 TS1M39.2
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M39.2
Microsoft Windows XP 64-bit Edition9.1 TS1M39.2
Microsoft Windows NT Workstation9.1 TS1M39.2
Microsoft Windows XP Professional9.1 TS1M39.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.