Tuesday, July 17, 2018

Measures and Measure Groups

A measure is a column in a table or view that contains data that can be
aggregated. Measures correspond to something that users are interested in
analyzing; such as revenue, profit, or the total number of items sold. A cube can
have one or more measures.


Measures are collected in a Measure Group. A Measure Group contains
measures, dimensions, partitions, and basic information about the measures.
Basic information includes the name of the measure group, type of measures,
storage mode, processing mode, and others.
In a cube, measures are grouped by their underlying fact tables into measure
groups. Measure groups are used to associate dimensions with measures.
 

Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...