Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services MDX calculations. NON EMPTY keyword can be used in MDX expression to exclude empty cells from a resultset. This performance counter monitors the total number of times a NON EMPTY keyword looped over calculated members.
Calculated members are members of a dimension or a measure group that are defined based on a combination of cube data, arithmetic operators, numbers, and functions. When you specify one or more measures in the Non-empty behavior list of a calculated member, Analysis Services treats the calculated member as empty if all the specified measures are empty
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Consider optimizing your MDX calculations
- Understand the differences between NON EMPTY keyword and NONEMPTY function
- Use SQL Server Profiler to monitor query definitions
- Use NON EMPTY while building axes or named sets instead of inside calculations whereby it will be referenced on every cell
Additional research
NonEmpty (MDX)
Defining Calculated Members
Optimizing MDX aggregation functions
Performance Counters (SSAS)