Planning Analytics system and feature configuration

You can use the following components and features to configure the Planning Analytics database and clients for maximum performance.

Configuration

Description

Tm1s.cfg file

A configuration file that specifies environment information for the TM1® Server TM1 Database 12 .

You can edit the Tm1s.cfg file to reflect the environment of the associated server.

For more information, see Planning Analytics Local Installation and Configuration.

Tm1p.ini file

A configuration file that specifies the environment information for the TM1 clients (TM1 Perspectives, TM1 Architect, and Client).

For more information, see Planning Analytics Local Installation and Configuration.

Multi-threaded Queries

Multi-threaded queries can calculate multiple streams of results in parallel to improve query performance. Multi-threaded queries allow Planning Analytics to automatically load balance the application of cores by running each query on a separate core. This multi-processing can improve efficiency and processing time for large queries and rules.

For more information, see Multi-threaded queries.

Capability Assignments

A set of capabilities that administrators can enable or disable by user group.

You can use capability assignments to manage options such as Personal Workspace Writeback Mode, Sandboxes, Data Reservation, and access to Server Explorer.

For more information, see Capability assignments.

Persistent Feeders

A parameter that can improve reload time of cubes with feeders, especially feeders with many complex calculations, by saving feeders and then reloading them at server startup without recalculating those feeders.

For more information, see Persistent feeders.

Sandboxes

A feature that allows users to create and work in their own data areas separate from base data.

Administrator tasks for this feature include understanding the feature and its memory usage, enabling the necessary configuration parameters and managing related files and folders.

For more information, see Sandboxes and personal workspaces.

Data Reservation

A server-related feature that you can use to configure exclusive write-access to regions of a cube for individual users. When it is reserved, the data in that region can be modified only by that specific user until the reservation is released.

Administrator tasks for DR include configuring related properties in the }CubeProperties control cube and the Capability Assignments window.

To apply and manage Data Reservations, you must use the related TurboIntegrator and API functions to programmatically obtain, release, and manage reservations.

For more information, see the "Using Data Reservations" and "Enabling Data Reservation" sections in TM1 for Developers.