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.
DBAs, Server administrators, BI developers
- Consider optimizing your MDX calculations
- You can use the EXISTING keyword to ensure auto-exist behavior in calculated members
- Use SQL Server Profiler to monitor query definitions
- Instead of Exists keyword, make use of the EXISTING keyword to improve the maintainability of your MDX code