This dialog box enables you to register other products’ function libraries or user-defined function libraries.
This dialog box is displayed when you click Register in the Calculated Member Builder.
You can create user-defined functions to provide functions not in the Microsoft® SQL Server™ OLAP Services function library. A user-defined function can be developed on any tool capable of generating Microsoft ActiveX® libraries.
You can register user-defined function libraries of the following types:
The OLAP Services functions always take precedence over registered function libraries when function name conflicts occur (that is, two libraries contain the same function name). Except OLAP Services functions, the order of the libraries in the list is important. It defines the precedence of function resolution in cases of name conflicts. The first library takes precedence.
OLAP Services automatically registers the Visual Basic® for Applications Expression Services function library (VBA332.dll) and the library that supports the Microsoft Excel worksheet functions. However, the Excel library must be installed separately from OLAP Services. For lists of supported functions, see “Visual Basic for Applications Functions” and “Excel Functions,” both in OLAP Services Books Online (msdssbol.chm).
Using the Register Function Libraries Dialog Box
Calling a User-defined Function within MDX