OLAP Examples

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The basic examples provided in this topic cover the most commonly employed functions of the Decision Support Objects (DSO) library. All of the examples are written in Microsoft® Visual Basic®, with additional code examples in Microsoft Visual C++® given on selected topics. The following table lists the topics covered.

Topic

Description

Working with Servers

Describes how to connect to an Analysis server

Working with Databases

Explains how to list, add, and delete databases for an Analysis server

Working with Data Sources

Shows how to list data sources on, add new data sources to, or delete existing data sources for a database

Working with Dimensions and Levels

Demonstrates how to list, add, and delete shared dimensions for a database

Working with Cubes and Measures

Describes how to list, add, delete, and process cubes for a database, including examples on how to list and add measures to a cube

Note

  The examples presented in this topic are for educational purposes. The code is intended to illustrate the functionality of the DSO library, and it does not contain error-handling routines.