How to add a measure group to an existing SSAS Cube.

Problem: How to add a measure group to an existing SSAS Cube.

Solution: Create Measures and Measure Groups

Measures and measure groups are the multidimensional objects that represent facts and fact tables in an external data warehouse. In most cases, measures and measure groups will be based on objects in a data source view, which in turn are created from the underlying data warehouse.

Example:

In this example, I would like to show we can add measure group to an existing cube.

Step 1: launch visual studio and open the data source view tab, for more information go through this article How to build a cube.

Step 2: Now go to the data source view and right click on the empty area to add the fact table which goes into the measure group and add related tables.

Step 3: from the solution explorer and open the cube folder and double click on the cube

Step 4: Now go to the cube structure tab and from the measures window right click on the empty area or click on the new measure group button from the ribbon.

Step 5: There will be a dialog box for adding a measure group and select the tables to add from the data source view.

 

Step 6: to browse the data from the new measure group, deploy and browse from excel to see new changes.

Results: