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