10.1. COM User Defined Functions

COM is Microsoft's architecture for building software from binary components that expose the functionality with a well-defined interface. Analysis Services understands the COM interface and has the ability to interface with any COM DLLs so that functions within the DLL can be accessed through MDX. In order to create a function that will perform a customized operation for your business, you need to create a DLL using any of the languages that allow you to create a COM DLL, such as Microsoft Visual Basic or Microsoft Visual C++. In this chapter you learn how to create a COM UDF using Visual Basic 6.0.

Get Professional SQL Server™ Analysis Services 2005 with MDX now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.