BI performance counter: Total NON EMPTY for calculated members

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

  1. Consider optimizing your MDX calculations
  2. Understand the differences between NON EMPTY keyword and NONEMPTY function
  3. Use SQL Server Profiler to monitor query definitions
  4. 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)

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index