This project has moved. For the latest updates, please go here.

TraceEvent

The function in the TraceEvent class is FireTraceEventAndReturnValue. It can be used to detect when Analysis Services is evaluating an expression since the function merely fires a trace event that appears in Profiler as a User Defined event, then returns the integer value you pass in. This function can be used in a scenario such as determining when the cell security expression is evaluated.

Here is an example MDX query displaying the usage of this function:

with member [Measures].[test] as ASSP.FireTraceEventAndReturnValue(99)
select [Measures].[test] on 0
from [Adventure Works]


The signature of the function is:
FireTraceEventAndReturnValue(int)

Last edited Dec 18, 2011 at 4:10 PM by furmangg, version 1