Analysis Services Objects

A Microsoft SQL Server 2005 Analysis Services (SSAS) instance contains database objects and assemblies for use with online analytical processing (OLAP) and data mining.

  • Databases contain OLAP and data mining objects, such as data sources, data source views, cubes, measures, measure groups, dimensions, attributes, hierarchies, mining structures, mining models and roles.
  • Assemblies contain user-defined functions that extend the functionality of the intrinsic functions provided with the Multidimensional Expressions (MDX) and Data Mining Extensions (DMX) languages.

In This Section

The following topics describe objects shared by both OLAP and data mining features in Analysis Services.

Topic Description

Data Sources (Analysis Services)

Describes a data source in Analysis Services.

Data Source Views (Analysis Services)

Describes a logical data model based on one or more data sources, in Analysis Services.

Cubes (Analysis Services)

Describes cubes and cube objects, including measures, measure groups, dimension usage relationships, calculations, key performance indicators, actions, translations, partitions, and perspectives.

Dimensions (Analysis Services)

Describes dimensions and dimension objects, including attributes, attribute relationships, hierarchies, levels, and members.

Mining Structures (Analysis Services)

Describes mining structures and mining objects, including mining models.

Roles (Analysis Services)

Describes a role, the security mechanism used to control access to objects in Analysis Services.

Assemblies (Analysis Services)

Describes an assembly, a collection of user-defined functions used to extend the MDX and DMX languages, in Analysis Services.

See Also


Unified Dimensional Model
Data Mining Concepts
Data Source Views (Analysis Services)
Working with Online Analytical Processing (OLAP)
Working with Data Mining

Other Resources

Working with Data Sources (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance