Offline cubes

Offline cubes enable you to save a snapshot of a cube locally and access it while not connected to the database server. You can reduce the dimensions, members, and measures saved to save space.

Access to this feature is enabled with a license key to control data access. Contact Support for more information.

If you right-click a cube connection, you get the option to go offline. Select Go Offline to open the offline setup screen. Here you pick the measures and dimensions you want to be able to use offline. Objects used in the workbook will be pre-selected, and you can add extra items as you wish. You also need to select a file to save the data to.

To reduce the offline file size, and the time taken to generate it, you can use a member selector to limit the data downloaded. This is accessed using the button next to each dimension.

If you right-click a cube connection that is offline in the connection screen, you can select to go back online. This changes the connection to refer to the original server and database. You can also refresh the offline data, for example, to get the latest data after an overnight cube process on the server.

If you want to change the dimensions and measures stored offline, you can go online and then back offline. You can update the offline file setup before going back offline.

When a report with an offline connection is published to the web, the connection in the published report will be returned online. It isn't possible to use Anaplan XL web reports in offline mode.

• Offline cubes are only available on Multidimensional Analysis Services connections.
• Distinct Count measures aren't supported.
• Dimensions with binary data aren't supported.
• All MDX calculations are created in the offline cube. Calculations that reference measures that aren't imported can cause MDXScript errors when using the cube file. If this happens, then the measures need to be included in the offline cube.