Microsoft® SQL Server™ OLAP Services version 7.0 provides three component tools you can use with your custom applications:
DSO is the server object model for OLAP Services. Your applications can use DSO to control the server and create and maintain OLAP objects such as cubes, dimensions, and roles. See Introducing Decision Support Objects.
Your applications can use the IOlapAddIn interface and associated objects to interact with the OLAP Manager’s user interface. You can add objects to the object tree view, add items to the right-click menus, and respond to menu items selected by the administrator. See Introducing Add-in Programs.
PivotTable Service enables your applications to connect to the OLAP server and query multidimensional data. You can also use PivotTable Service to create cubes from OLAP server data or relational data sources and store them locally for use when not connected to the OLAP server. See Introducing PivotTable Service.
You can use any combination of these tools to create applications that help you manage your OLAP Services installation and provide OLAP data to your end users.