Measures
Measures provide the actual information that the users of our cubes are interested in. Measures are the bits of numerical data that we need to aggregate. Measures come from the fields in the fact tables in the data mart.
Eg: Accepted Products, Rejected Products, Inventory Fact Count, Number on Back Order
Measure Group
Each measure group in a cube corresponds to a table in the data source view. This table is the measure group’s source for its measure data. The measure group is said to be bound to this table. Each record in the table becomes a different
member of the measure group.
Eg: Manufacturing Fact, Inventory Fact
Source: Delivering Business Intelligence with Microsoft SQL Server 2012 (3rd Edition) Author: Brian Larson
Measures provide the actual information that the users of our cubes are interested in. Measures are the bits of numerical data that we need to aggregate. Measures come from the fields in the fact tables in the data mart.
Eg: Accepted Products, Rejected Products, Inventory Fact Count, Number on Back Order
Measure Group
Each measure group in a cube corresponds to a table in the data source view. This table is the measure group’s source for its measure data. The measure group is said to be bound to this table. Each record in the table becomes a different
member of the measure group.
Eg: Manufacturing Fact, Inventory Fact
Source: Delivering Business Intelligence with Microsoft SQL Server 2012 (3rd Edition) Author: Brian Larson
No comments:
Post a Comment