Version 2021

Storing Intelligent Cubes in Secondary Storage

Along with storing Intelligent Cubes in Intelligence Server memory, you can also store them in secondary storage, such as a hard disk. These Intelligent Cubes can then be loaded from secondary storage into Intelligence Server memory when reports require access to the Intelligent Cube data.

To Store an Intelligent Cube in Secondary Storage

  1. In Developer, log in to a project source with administrative privileges.
  2. Right-click the project and select Project Configuration.
  3. Expand Intelligent Cubes, and then select General.
  4. In the Intelligent Cube file directory area, click ... (the Browse button).
  5. Browse to the folder location to store Intelligent Cubes, and then click OK.
  6. Click OK.
  7. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes.
  8. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk.

You can also define when Intelligent Cubes are automatically saved to secondary storage, as described in Defining when Intelligent Cubes are Automatically Saved to Secondary Storage below.

Defining when Intelligent Cubes are Automatically Saved to Secondary Storage

In addition to manually saving Intelligent Cubes to secondary storage, you can also define when Intelligent Cubes are automatically saved to secondary storage.

To Define when Intelligent Cubes are Automatically Saved to Secondary Storage

  1. In Developer, log in to a project source with administrative privileges.
  2. From the Administration menu, point to Server, and then select Configure MicroStrategy Intelligence Server.
  3. Expand the Server Definition category, and select Advanced.
  4. In the Backup frequency (minutes) field, type the interval (in minutes) between when Intelligent Cubes are automatically saved to secondary storage. A value of 0 means that Intelligent Cubes are backed up immediately after they are created or updated.

    Be aware that this option also controls the frequency at which cache and History List messages are backed up to disk, as described in Configuring Result Cache Settings.

  5. Click OK.
  6. Restart Intelligence Server for your changes to take effect.