Set database configuration parameters

You can set configuration parameters that determine the behavior of your databases.

About this task

The Planning Analytics Administration interface provides access to Planning Analytics database parameters. Only the parameters listed here can be set through Planning Analytics Administration.

Parameters are organized in Administration, Modelling, Performance, and Access categories, and then further arranged by functional category.

The Planning Analytics Administration interface provides a brief description for each parameter, along with an indication of the default parameter value.

Administration category
Default: AllowReadOnlyChoreReschedule; DisableSandboxing; Language; MaskUserNameInServerTools; PerfMonActive; PerformanceMonitorOn; RunningInBackground; StartupChores; UnicodeUpperLowerCase
Audit log: Enable
Clients: ClientPropertiesSyncInterval
External databases: SQLRowsetSize
Server log: Enable; ExcelWebPublishEnabled
Top log: Enable; TopScanFrequency

Modelling category
Default: DefaultMeasuresDimension; EnableNewHierarchyCreation; MDXSelectCalculatedMemberInputs; UserDefinedCalculations
Rules: AllowSeparateNandCRules; AutomaticallyAddCubeDependencies; ForceReevaluationOfFeedersForFedCellsOnDataChange; RulesOverwriteCellsOnLoad
Spreading: ProportionSpreadToZeroCells; SpreadingPrecision
Startup: LoadPrivateSubsetsOnStartup; MaximumCubeLoadThreads; PersistentFeeders
Synchronization: MaximumSynchAttempts
TI: EnableTIDebugging; MaximumTILockObjects; UseExcelSerialDate

Performance category
Default: PrivilegeGenerationOptimization
JobQueuing: Enable; MaxWaitTime; ThreadPoolSize; ThreadSleepTime
Locking: PullInvalidationSubsets; UseLocalCopiesForPublicDynamicSubsets
Memory: ApplyMaximumViewSizeToEntireTransaction; CacheFriendlyMalloc; DisableMemoryCache; LockPagesInMemory; MaximumMemoryForSubsetUndoKB; MaximumViewSizeMB
MTCubeLoad: Enabled; MinFileSize; UseBookmarkFiles; Weight
MTFeeders: Enabled; AtStartup
MTQ (multi-threaded queries): MTQQuery; MTQ.ImmediateCheckForSplit; NumberOfThreadsToUse; SingleCellConsolidation
Stargate: AllRuleCalcStargateOptimization; UseStargateForRules; ZeroWeightOptimization
View calculation: CalculationThresholdForStorage; CheckFeedersMaximumCells; MagnitudeDifferenceToBeZero; ViewConsolidationOptimization

Access category
Authentication: MaximumLoginAttempts
CAM: CreateNewCAMClients
CAPI: MessageCompression; ProgressMessage

Set database configuration parameters in Planning Analytics Workspace

Procedure

On the Databases page, click the Databases tab.
In the list of databases, click the database for which you want to set configuration parameters.
Click the Configuration tab.
Locate the parameter that you want to modify, then set a new parameter value.
Click Apply.

Database configuration parameters are identified on the Configuration tab as either dynamic or static. Dynamic parameter values can be changed without requiring a database restart. Changes to static parameter values require a database restart.
You can click Restore to original values at any time to restore all of the listed parameters to their default values.