Export (0) Print
Expand All

How to build a cube with Cube Editor

SQL Server 2000

To build a cube with Cube Editor

  1. In the Analysis Manager tree pane, expand the database in which you want to build a cube.

  2. Right-click the Cubes folder, point to New Cube, and then click Editor.

  3. In the Choose a fact table dialog box, expand a data source, and then click the table to use as your cube's fact table.

    The columns of the table you click appear under Details.

  4. Click OK.

    Cube Editor appears, with your fact table showing in the Schema tab.

  5. To select measures for your cube, in the Cube Editor tree pane, right-click the Measures folder, and then click New Measure. Use the Insert Measure dialog box to select columns in your fact table as measures.

    As you select each measure, it appears in the tree pane under the Measures folder.

  6. Select existing shared dimensions or define new dimensions for your cube.
    • Existing shared dimensions: In the Cube Editor tree pane, right-click the Dimensions folder, and then click Existing Dimensions. Select existing shared dimensions under Shared dimensions, and then click > to add them to your cube.

    • New dimensions: In the Cube Editor tree pane, right-click the Dimensions folder, and then click New Dimension. Use the Dimension Wizard to create a new dimension. If you want the dimension to be private, in the Finish step, clear the Share this dimension with other cubes check box.

    After you select or define a dimension, its dimension table appears in the Schema tab of Cube Editor, with the join between the dimension table and the fact table illustrated by a line. Also, a dimension table can be joined to another dimension table to form a snowflake schema. Verify that all desired joins are present. To add a join, drag a column to the joining column.

  7. To save your cube, on the File menu, click Save, type a name for your cube in the New Cube Name dialog box, and then click OK.

    The new name for your cube appears in the Cube Editor tree pane.

  8. To design the aggregations for your cube, on the Tools menu, click Design Storage. The Storage Design Wizard appears to help you design aggregations.

    The last step of the wizard gives you the option to process your cube now or later. You must process it before you and end users can view its data. Depending on the size of your cube, processing can take considerable time.

Note  Newly processed cubes are visible to end users only after they reconnect to the server computer.

See Also

Building a Cube with the Editor


Designing Storage Options and Aggregations

Processing Cubes

© 2015 Microsoft