Dimensions Configuration

Dimensions functionality is disabled by default because it has a significant impact on performance.  It should only be enabled when dimensions will be utilized.

Dimensions can have a significant impact on performance in certain scenarios, so this should be considered before enabling.  Complex queries may require optimization.

IMPORTANT!  Once dimensions functionality is enabled, it can not be disabled.  A feature may be added in the future to remove dimension content and disable dimensions, but at this time it is not possible and it will cause database corruption and unexpected results to disable dimensions after they were enabled.

To enable dimensions:

  1. In the root folder, import (where "/var/www/webcomand" is the webCOMAND folder path):
  2. From the API app, enable Dimensions from an SQL tab with:
    UPDATE SystemSettings SET Dimensions=1