Setting the attribute HOLAP_COMPUTED_COLUMNS_EXPAND=1 for the MDDB Data Provider (MDP) class allows you to enable the expand functionality that would normally be disabled in some cases. This setting will override the default behavior of disabling expansion when server side computed column evaluation is enabled.

By default, the ability to expand a Multidimensional Report is disabled when computed columns are evaluated on the remote server because, in some cases, complex computed columns may not return the correct results due to the order the computations are evaluated. This behavior is documented to be overridden by setting HOLAP_COMPUTED_COLUMNS_EXPAND=1.

However, when both expansion and server side computed columns are enabled, such as with HOLAP_COMPUTED_COLUMNS_EXPAND=1 and HOLAP_COMPUTED_COLUMNS=1, expansion will not work within a multidimensional report. This worked prior to SAS^® 9.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :