Building Add-ins

Analysis Services Programming

Analysis Services Programming

Building Add-ins

To create a custom add-in, add Microsoft OLAP Services Add-ins Manager to the available references for your Microsoft® Visual Basic® project. This library contains the classes, objects, methods, properties, enumerations, and collections you can use in your program. For more information, see Tutorial - Creating a Sample Add-in and Programmer's Reference (Add-ins).

Decision Support Objects (DSO) can also be used in a custom add-in. To use DSO in an add-in, add Microsoft Decision Support Objects to the available references for your project. For more information, see Using Decision Support Objects.

Your add-in can add nodes to the structure in the tree pane as the user selects or expands a node and can augment node menus with items that will cause your program to be called when those items are selected.

The Microsoft OLAP Services Add-Ins Manager library calls your custom add-in to display the objects in the Analysis Manager user interface and to respond to user activity. If your program does not implement the required IOlapAddIn interface as specified here, Analysis Manager may fail to operate as designed.

To create a Microsoft SQL Server™ 2000 Analysis Services add-in, you must:

  • Create a Microsoft ActiveX® DLL project in Visual Basic, using the name of your custom add-in as the project name.

  • Create one publicly exposed class that implements the IOlapAddIn interface.

  • Provide your own implementation of each of the IOlapAddIn methods.

  • Register your custom add-in in the registry.

See Also

Decision Support Objects

IOlapAddIn Interface