SQL

Analysis Services

Analysis Services

SQL

Microsoft® SQL Server™ 2000 Analysis Services supports SQL queries or clauses in filters. A filter is the section of a Structured Query Language (SQL) SELECT statement that follows the WHERE keyword. That is, it is the list of predicates that make up the WHERE clause of the SELECT statement. The following topics describe how filters are used in Analysis Services.

Topic Description
Partition Filters and Incremental Update Filters Describes the filters specify the data to be incorporated into the partitions of a cube.
Dimension Filters Describes the filters that specify which members from a dimension table will be used to build a dimension.
Drillthrough Filters Describes the filter that specifies which aggregation elements are returned when users drill through to the source data. For more information about using drillthrough, see Using DRILLTHROUGH to Retrieve Source Data.

You can use a filter to limit the following:

  • The dataset of a partition

  • The dataset of a dimension

  • The rows used during an incremental update

  • The rows returned by drillthrough

In PivotTable® Service, SQL can be used to query data, build local cubes, and build data mining models. For more information, see PivotTable Service.

Analysis Services is both a multidimensional data provider and a tabular data provider. Therefore, executing a query returns either a multidimensional dataset or a flattened rowset, depending on the query language dialect used. Analysis Services recognizes two dialects: SQL and Multidimensional Expressions (MDX). For more information, see SQL in Analysis Services.

See Also

PivotTable Service

Partition Filters and Incremental Update Filters

Dimension Filters

Drillthrough Filters