Common Operations and Examples
Nota
Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.
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