LoadPrivateSubsetsOnStartup

This configuration parameter determines if private subsets are loaded when the Planning Analytics database starts.

Parameter type: optional, static

Lock contention issues can occur when private subsets are loaded on-demand (when a user requests the subset). You can avoid lock contention by loading all private subsets from all users into memory upon server startup, by adding

LoadPrivateSubsetsOnStartup=T

to the Planning Analytics database configuration.

If LoadPrivateSubsetsOnStartup=F, or is not present in the Planning Analytics database configuration, private subsets are loaded on-demand.