Strategy One

Reduce Cube File Size By Up to 50% Using Cache Compression

This former preview feature, introduced in MicroStrategy ONE Update 10, is out of the box starting in MicroStrategy ONE Update 11.

Starting in MicroStrategy ONE Update 10, you can utilizecache compression to reduce cube file size by up to 50%. As you increasingly generate cubes with data, the resources required to store cube files on disk increases. The time and resources required to keep cubes synced between nodes after edits are made on another node also increase. You can use this feature to slow your resource utilization as it implements fast compression for cube serialization and deserialization. In MicroStrategy ONE update 10, this feature is disabled by default. In MicroStrategy ONE Update 11 and newer, this feature is enabled by default. You can enable and disable cache compression using one of the procedures below.

Enable or Disable Cache Compression in MicroStrategy ONE Update 11 and newer:

  1. Open the Workstation window.

  2. In the Navigation pane, click Environments.

  3. Right-click your connected environment and choose Properties.

  4. In the left pane, click All Settings.

  5. Enable or disable Compression for Intelligent Cube cache files in Linux.

  6. Click OK.

  1. Open the Strategy REST API Explorer by appending /MicroStrategyLibrary with /api-docs/index.html?visibility=all in your browser.

  2. Create a session and authenticate it. In the Authentication section, use POST /api/auth/admin/login.

  3. Click Try Out and modify the request body by providing your user name and password.

  4. Click Execute.

  5. In the response, find X-MSTR-AuthToken.

  6. To get the current feature status:

    1. Under the Configurations section, look up GET ​/api​/v2/configurations​/featureFlags​.

    2. Click Try Out.

    3. Set the proper X-MSTR-AuthToken from step 5. You can also get this via inspecting the browser network XHR requests.

    4. Click Execute.

    5. Search for FCC in the response body to find its status details.

  7. Under the Configurations section, look up PUT ​/api​/configurations​/featureFlags​/{id}.

  8. Click Try Out.

  9. Set the proper X-MSTR-AuthToken from step 5. You also can get this via inspecting the browser network XHR requests.

  10. Set id to D148530D519D4CBD5E68307E97FE4674.

  11. To enable this preview feature, set the status value to 1.

  12. Click Execute.

  13. Repeat step 6 to verify that the feature is enabled.