Export (0) Print
Expand All
9 out of 15 rated this helpful - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.