Advanced Examples

SQL Server 2008 R2


  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 examples in this topic assume that you are familiar with using Decision Support Objects (DSO) to create databases, data sources, dimensions and cubes. These advanced examples include the creation of virtual and linked cubes and virtual dimensions, as well as the capability to perform incremental updates on a cube. The following table lists the examples covered.



Working with Virtual Cubes

Gives information and examples on creating virtual cubes in DSO

Working with Linked Cubes

Provides information and examples in DSO on creating linked cubes

Working with Virtual Dimensions

Describes the creation of virtual dimensions in DSO

Working with Roles

Details the differences between database, cube, and mining model roles, providing examples on the creation of roles in DSO

Incremental Updates

Provides information and examples on processing incremental updates in DSO

Community Additions