Enter advanced configuration settings in Analysis Studio

Advanced configuration settings provide additional functionality. For example, set the maximum number of active areas in a chart.

Select ReportService as the required dispatcher.

Type the parameter name in the Parameter column. For example, ANS.PageSize.

In the Value column, type the associated value. For example, 200.

The following table lists the advanced configuration settings for Analysis Studio with their associated Parameter and Value entries.

Tip: Adjusting advanced configuration settings from recommended values can improve or degrade server performance.
Table 1. Analysis Studio advanced configuration settings

Advanced Setting

Parameter

Recommended Value

Limit the size of pages displayed at one ime on the cross-tab rows

ANS.PageSize

200

Limit the size of pages displayed at one time on the cross-tab columns

ANS.ColumnPageSize

50

Viewing user interface with missing or inaccessible member

ANS.showMissingMemberUI

1

Maximum number of active areas in a chart

ANS.MaxChartHotAreas

600

Enable selection based suppression

ANS.EnableSelectionBased Suppression

1

Enable automatic position calculations feature

ANS.EnabledPositionedCalcs

1

Optimize queries based on previous gestures

ANS.AdaptiveQueryOptimizationEnabled

1

Allow default visible item count per set to be changed

ANS.DefaultVisibileItemCount

12

Default value for output purpose drill

ANS.DefaultOutputPurpose

drill

Disable the ability for the product to save a user changed column width with an analysis

ANS.EnableColumnWidthPersist

1

With column width enabled, this parameter controls the maximum number of resized columns stored in the most recently used list

ANS.PersistColumnWidthMRU

100

For more information on how to apply advanced settings, see Configuring advanced settings for specific dispatchers.