MDX Profiling
Without any doubt, one of the most challenging tasks facing every MDX programmer is reducing the processing time for queries. Without support from the OLAP server, it is very difficult to determine how long any part of the query is taking. The profiler is also the natural companion of the Debugger and can be views as representing the debugger tree result in a consolidated table.
Profiling your MDX query is done from within the MDX editor; click on the profile icon. The profiling result is shown in a table:
In our example, we can see that most of the time is spent within the processing of the calculated member [Vol]. As you can see selecting a part of the query in the left panel is highlighting the corresponding MDX statement in the editor.
Next chapter: Schema Management is describing how cubes can be (un)loaded and how to access some statistics about them.