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
- Audit log
- Enable
- Clients
- ClientPropertiesSyncInterval
- Server log
- Enable
- Modelling category
- Default
- EnableNewHierarchyCreation
- Rules
- AllowSeparateNandCRules
- Spreading
- SpreadingPrecision
- Startup
- MaximumCubeLoadThreads
- Synchronization
- MaximumSynchAttempts
- TI
- EnableTIDebugging
- Performance category
- JobQueuing
- Enable
- Locking
- UseLocalCopiesForPublicDynamicSubsets
- Memory
- ApplyMaximumViewSizeToEntireTransaction
- MTCubeLoad
- Enabled
- MTFeeders
- Enabled
- MTQ (multi-threaded queries)
- NumberOfThreadsToUse
- Stargate
- AllRuleCalcStargateOptimization
- View calculation
- CalculationThresholdForStorage
- Access category
- Authentication
- MaximumLoginAttempts
- CAM
- CreateNewCAMClients
- CAPI
- MessageCompression