Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

ServerMath

Use this command to turn all server calculations (rollup, server rules, translations, etc.) on or off. For example, when you change the value of a symbol and submit the changed value, your system calculates the values of the ancestors of the symbol, up to the root symbol in each hierarchy.

Since this operation may slow down performance, use the ServerMath command to turn off the server calculation when you run processes that change many cells (for example, a period-end rollover). You will need to perform an enterprise restatement once you have finished submitting all the data.

This command must be used in conjunction with Maintenance. While it is enabled, no other users can perform maintenance related activities in the Data Server repository. When you are finished, you must remember to disable the Maintenance mode, and thereby allow normal access by other users. For more information, see Maintenance or Exclusive.

Syntax:

SERVERMATH StatusType [CURRENTSESSION]

where:

  • StatusType can be one of the following:
    Value Description

    ON

    To perform data server calculations automatically as cells are submitted to the Data Server repository.

    OFF

    To stop calculating as cells are submitted to the Data Server repository.

    OFF CURRENTSESSION

    To turn off the ServerMath flag for the current user session only (does not require Maintenance mode).

    DEFAULT CURRENTSESSION

    To restore the ServerMath flag to the default after using the OFF CURRENTSESSION command (does not require Maintenance mode). Users are not allowed to turn on the ServerMath flag for the session, but they can turn it off. Once the user disconnects or signs off, the changed setting is lost.

Syntax example:

MAINTENANCE ON

SERVERMATH ON

SERVERMATH DEFAULT CURRENTSESSION

SERVERMATH OFF

CURRENTSESSION

MAINTENANCE OFF

Published:

ServerMath

Use this command to turn all server calculations (rollup, server rules, translations, etc.) on or off. For example, when you change the value of a symbol and submit the changed value, your system calculates the values of the ancestors of the symbol, up to the root symbol in each hierarchy.

Since this operation may slow down performance, use the ServerMath command to turn off the server calculation when you run processes that change many cells (for example, a period-end rollover). You will need to perform an enterprise restatement once you have finished submitting all the data.

This command must be used in conjunction with Maintenance. While it is enabled, no other users can perform maintenance related activities in the Data Server repository. When you are finished, you must remember to disable the Maintenance mode, and thereby allow normal access by other users. For more information, see Maintenance or Exclusive.

Syntax:

SERVERMATH StatusType [CURRENTSESSION]

where:

  • StatusType can be one of the following:
    Value Description

    ON

    To perform data server calculations automatically as cells are submitted to the Data Server repository.

    OFF

    To stop calculating as cells are submitted to the Data Server repository.

    OFF CURRENTSESSION

    To turn off the ServerMath flag for the current user session only (does not require Maintenance mode).

    DEFAULT CURRENTSESSION

    To restore the ServerMath flag to the default after using the OFF CURRENTSESSION command (does not require Maintenance mode). Users are not allowed to turn on the ServerMath flag for the session, but they can turn it off. Once the user disconnects or signs off, the changed setting is lost.

Syntax example:

MAINTENANCE ON

SERVERMATH ON

SERVERMATH DEFAULT CURRENTSESSION

SERVERMATH OFF

CURRENTSESSION

MAINTENANCE OFF

For an optimal Community experience, Please view on Desktop