One of the issues that we face in the Microsoft-centric Business Intelligence world is the fact that the tools (From the client stack all the way to the development environment) make things relatively easy for the "happy path" (That place where most of the people want to go) but any time you step off that path, you really have to interact with the MultiDimensional Query eXpressions (MDX) language. To say that MDX is complicated would be tantamount to saying that the Grand Canyon is deep.
Fortunately, Mosha Pasumansky (The "father" of MDX) understands this, and has recently released a tool to assist developers that need to interact with MDX. The tool is called, "MDX Studio" (imagine that!) and is available for free download from the new Microsoft Live skydrive service here: http://cid-74f04d1ea28ece4e.skydrive.live.com/browse.aspx/MDXStudio/v0.1
Here's a screen shot of MDX studio running on my laptop: