• 아티클

Common Operations and Examples

[!참고]

  이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.

This topic provides basic and advanced examples, in a step-by-step format, that show you how to perform common operations using Decision Support Objects (DSO). These examples assume that you have some experience in creating Microsoft® Visual Basic® or Visual C++® database applications. The examples provide complete routines in Visual Basic that perform the following functions:

  • Connects to your Analysis server

  • Accesses the FoodMart 2000 sample database

  • Adds a new database and data source

  • Adds dimensions and levels

  • Adds a cube and measures

  • Processes the cube

  • Creates a virtual cube

  • Creates a linked cube

  • Creates virtual dimensions

  • Performs incremental updates on a cube

The examples use DSO objects to create a cube derived from the FoodMart 2000 sample database, which is provided with Analysis Services. It uses the Sales_Fact_1997, Product, Store, and Time_By_Day tables in a star schema, as shown here.

The following dimensions and measures are also used, as shown here.

You may also find it helpful to review the structure of the FoodMart 2000 database itself by examining it either in Microsoft Access or in a third-party computer-aided software engineering (CASE) tool. This will help you to understand how the preceding steps are applied to the specific instance of the FoodMart 2000 database.

Some of these exercises can modify the FoodMart 2000 sample database. We recommend that you make backup copies of the following directories before you proceed:

  • C:\Program Files\Microsoft Analysis Services\Bin

  • C:\Program Files\Microsoft Analysis Services\Data