Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

11.5. Summary

Did the impending sense of programming power make you dizzy while reading? You no doubt experienced a thrill akin to a roller coaster ride while reading this chapter. Think about it. There is a way to do basically whatever you want programmatically as long as you are capable of coding it up in concert with all the power of SQL Server Analysis Services 2008. Consider what you learned in the three sections of this chapter. In the first section you learned about the built-in UDFs that provide the power of VBA and Excel functions in MDX. In the second section you learned how to create stored procedures using the ADOMD Server and AMO object models. Finally, you learned how to use an existing COM UDF in MDX queries. You also learned under what circumstances COM UDF is preferred over a .NET UDF. With the help of the UDFs you can now perform any custom operations that you need in your multidimensional database. You have so far learned to design and refine your databases. In the next chapter you learn the intricacies of updating underlying UDM data on dimensions as well as cells.