Cube Wizard

You can use the Cube Wizard to create local cubes for when there is no connection to an Analysis Services database alias. This tool is only available for Analysis Services databases.

By default, when you create a local cube, the cube definition is saved to a file which you specify. If, for example, you send the cube to another user, that user can create a database alias in which the Server Name is the path to the local cube file, instead of the computer name.

See Using a local cube file (Analysis Services only).

Optionally, you can choose to register a database alias for the cube. This is convenient if you will use the cube on the computer on which you create it.

To create a local cube:

  1. Log on to the Analysis Services database alias from which to create the cube.
  2. Select Tools > Cube Wizard.
  3. Select the Analysis Services database alias from the Database list.
  4. Select the cube from which to create the local cube.
    The Values and Dimensions fields are populated.
  5. In the Values field, select the value to use as a measure.
  6. In the Dimensions field, select the dimensions to include in the local cube.
  7. Click the File Name browse button and specify a name and location for the local cube file.
    Local cubes have the .cub file extension.
  8. The MDX Query field displays the MDX definition of the local cube.
    This link has information about the MDX definition of a cube:
  9. Optionally, select Register as new alias with name: and specify a name for the database alias.
  10. Click Save.
  11. Click OK at confirmation that the cube has been created.
  12. Click Close.
Parent topic: Tools