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.

Each parameter includes a brief description, along with an indication of the default parameter value. For complete details on all database configuration parameters, see Parameters in the tm1s.cfg file.

Administration category
Default
AllowReadOnlyChoreReschedule
DisableSandboxing
Language
MaskUserNameInServerTools
PerfMonActive
PerformanceMonitorOn
RunningInBackground
UnicodeUpperLowerCase
Audit log
Enable
Clients
ClientPropertiesSyncInterval
Server log
Enable
ExcelWebPublishEnabled
Modelling category
Default
EnableNewHierarchyCreation
DefaultMeasuresDimension
UserDefinedCalculations
Rules
AllowSeparateNandCRules
AutomaticallyAddCubeDependencies
ForceReevaluationOfFeedersForFedCellsOnDataChange
RulesOverwriteCellsOnLoad
Spreading
SpreadingPrecision
Startup
MaximumCubeLoadThreads
PersistentFeeders
Synchronization
MaximumSynchAttempts
TI
EnableTIDebugging
MaximumTILockObjects
UseExcelSerialDate
Performance category
JobQueuing
Enable
MaxWaitTime
ThreadPoolSize
ThreadSleepTime
Locking
UseLocalCopiesForPublicDynamicSubsets
Memory
ApplyMaximumViewSizeToEntireTransaction
CacheFriendlyMalloc
DisableMemoryCache
LockPagesInMemory
MaximumMemoryForSubsetUndoKB
MaximumViewSizeMB
MTCubeLoad
Enabled
MinFileSize
UseBookmarkFiles
Weight
MTFeeders
Enabled
AtStartup
MTQ (multi-threaded queries)
NumberOfThreadsToUse
SingleCellConsolidation
Stargate
AllRuleCalcStargateOptimization
UseStargateForRules
ZeroWeightOptimization
View calculation
CalculationThresholdForStorage
CheckFeedersMaximumCells
ViewConsolidationOptimization
Access category
Authentication
MaximumLoginAttempts
CAM
CreateNewCAMClients
CAPI
MessageCompression
ProgressMessage

Set database configuration parameters in Planning Analytics Workspace

Procedure

  1. On the Databases page, click the Databases tab.
  2. In the list of databases, click the database for which you want to set configuration parameters.
  3. Click the Configuration tab.
  4. Locate the parameter that you want to modify, then set a new parameter value.
  5. 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.

  6. You can click Restore to original values at any time to restore all of the listed parameters to their default values.

Set database configuration parameters in Planning Analytics Workspace Classic

Procedure

  1. Click the database tile name on the Databases page.
  2. Click Configuration icon on the database activity report.
  3. Click Database configuration.
  4. Locate the parameter that you want to modify, then set a new parameter value.
  5. Click Apply.

    Database configuration parameters are identified on the Database configuration page 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.

    If you modify a static parameter, you receive notification that the database must be restarted before the new parameter value can be applied. You can restart the database from the Planning Analytics Monitoring dashboard.

  6. You can click Restore at any time to restore all of the listed parameters to their default values.