Condividi tramite

Common Operations and Examples

  • Articolo

[!NOTA]   Questa funzionalità verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa funzionalità in un nuovo progetto di sviluppo e modificare appena possibile le applicazioni in cui questa funzionalità viene utilizzata.

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