BI performance counter: Total EXISTING

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services MDX calculations. This performance counter monitors the total number of times an EXISTING MDX set operation was performed. By default, sets are evaluated within the context of the cube that contains the members of the set, however, the EXISTING operator forces the set operation to be computed inside the current context.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Consider optimizing your MDX calculations
  2. You can use the EXISTING keyword to ensure auto-exist behavior in calculated members
  3. Use SQL Server Profiler to monitor query definitions
  4. Instead of Exists keyword, make use of the EXISTING keyword to improve the maintainability of your MDX code

Additional research

EXISTING Keyword (MDX)
SQL SSAS: Exists vs. Existing and Auto Exist in MDX
MDX EXISTING keyword
Performance Counters (SSAS)

⇐ Back to index