Tutorial 14: MSAS : Building the Cube Part #3

Article Index
Tutorial 14: MSAS : Building the Cube Part #3
Page 2

Page 2 of 2

We will select Store table from the dialog box. Then we will connect the region and Store table and Click Add. The table does not close but it adds the store table to the Cube Wizard. The dialog box has to be closed by clicking Close.

Note that the Wizard has added the table to the cube and induces a join between the region table and the store table. The obvious choices are made by default, but the accuracy of the join should be examined. Here the common field is the region_id and the join is made on that

Now the join between the Store table and the Fact table needs to be established via the store_id if the Wizard has not already established it. The link can be established by dragging the store_id field in the store table to the store_id field in the sales_fact_1998 table. If a wrong join has been established by mistake, the same can be removed by clicking on it with the left mouse button to highlight it and then right clicking on it for the remove option.

Now we can exit the cube by selecting Exit in the file menu option. We are prompted to save our cube after our changes. We click Yes. We are then prompted to design storage options in the Design storage dialog. Here we have an option to save and come back later or proceed with the process of designing the storage and processing the cube

Tags