Create a Cube Using the Cube Wizard

You can create a new cube by using the Cube Wizard in SQL Server Data Tools (SSDT).

To create a new cube

  1. In Solution Explorer, right-click Cubes, and then click New Cube.

  2. On the Select Creation Method page of the Cube Wizard, select Use existing tables, and then click Next.

    Note

    You might occasionally have to create a cube without using existing tables. To create an empty cube, select Create an empty cube. To generate tables, select Generate tables in the data source.

  3. On the Select Measure Group Tables page, do the following procedures:

    1. In the Data source view list, select a data source view.

    2. In the Measure group tables list, select the tables that will be used to create measure groups.

    3. Click Next.

  4. On the Select Measures page, select the measures that you want to include in the cube, and then click Next.

    Optionally, you can change the names of the measures and measure groups.

  5. On the Select Existing Dimensions page, select the existing dimensions to include in the cube, and then click Next.

    Note

    The Select Existing Dimensions page appears if dimensions already exist in the database for any of the selected measure groups.

  6. On the Select New Dimensions page, select the new dimensions to create, and then click Next.

    Note

    The Select New Dimensions page appears if any tables would be good candidates for dimension tables, and the tables have not already been used by existing dimensions.

  7. On the Select Missing Dimension Keys page, select a key for the dimension, and then click Next.

    Note

    The Select Missing Dimension Keys page appears if any of the dimension tables that you specified do not have a key defined.

  8. On the Completing the Wizard page, enter a name for the new cube and review the cube structure. If you want to make changes, click Back; otherwise, click Finish.

    Note

    You can use Cube Designer after you complete the Cube Wizard to configure the cube. You can also use Dimension Designer to add, remove, and configure attributes and hierarchies in the dimensions that you created.