In a cube, measures are grouped by their underlying fact tables into measure groups. This performance counter relates to the measurement of Analysis Services storage engine queries. It monitors the total number of measure group queries that were processed since the restart of the Analysis Services instance.
DBAs, Server administrators, BI developers
- Set the ‘IgnoreUnrelatedDimensions’ measure group property to ‘False’ so you can hide measure values when seen against an unrelated dimension attribute
- Create multiple partitions for a measure group with very large fact tables
- Optimize the data types of fields used by Analysis Services at the source database