Databases Reference
In-Depth Information
conditions where you do not use the object models of Analysis Services. If
you are using the ADOMD Server object model, debugging the stored pro-
cedure external to Analysis Services is difficult especially in the conditions
where differences between client and server models exist. For example, the
server ADOMD has an object called MDXExpression that helps you to evalu-
ate MDX expressions within your stored procedure. This is not available in
the client object model, so you will need a different method for debugging
your stored procedure. The new method is not that complicated and is similar
to debugging any program, but you need to debug within Analysis Services.
Assume you want to debug your ADOMD stored procedure example in this
chapter because you are not getting expected results. The following steps
show how to debug it:
1. Execute the MDX query using the stored procedure.
2. Launch Visual Studio and attach it to your Analysis Server instance.
You can attach the debugger to Analysis Services by selecting Tools
Attach to Process. In the Attach to process window search for the
process msmdsrv.exe, select the process. Select Managed and Nat-
ive options for Attach to as shown in
Figure 10-6
and click Attach.
Figure 10-6
3. Now you need to make sure you load all the symbol information of
your stored procedure. For this, select Debug Window Modules in
Visual Studio. You will now see the modules window that shows all
Search WWH ::
Custom Search