A Measure is single Numeric value (Means single column in a table) whereas a Measure Group is a collection of measures or we can simply say group of all the columns present in a table. For instance, In fact internet sale table [Sales Amount] and [Tax Amount] are the individual measures and group of all the columns are considered as Measure group.
Creating SSAS Measure Group Example
After the completion of creating Empty OLAP Cube using Wizard we have to create Measures or Measure Groups. Before we start creating New Measure Group let us see our Measures Pane in Cube Editor
To create a new measure group, Within the Measures pane ,right-click on the cube name will open the context menu for creating Measures.
From the above context menu we have two options such as New Measure and New Measure Group. In this example we are creating measure group so please select the New Measure Group option.
NOTE: When we select the New Measure Group option then all the columns present in the table will be selected by default. Most of the times we don’t require all the columns present in the fact table, so this is very bad option to be frank.
Once you selected the New Measure Group option, New Measure Group window will be opened and it will display all the tables available in the Data Source View.
Here we are selecting FactInternetSales table from the list.
Click ok to finish configuring the SSAS Measure Group (Fact Internet Sales). Let us see the Measures Pane for the newly created Measure Group.
If you look at the above screenshot you can understand why this is bad choice. If we don’t want any measure like Revision Member then we have to remove it explicitly.
Thank you for Visiting Our Blog