SQL in Analysis Services

Microsoft® SQL Server™ 2000 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 used. Analysis Services can interpret and process queries in both SQL and Multidimensional Expressions (MDX).

In addition to querying, you can use certain data definition language (DDL) statements to create local cubes, calculated members, user-defined sets, and cache. For more information, see PivotTable Service.

For more information about OLE DB, OLE DB for OLAP, and the MDX syntax as defined by OLE DB for OLAP, see the OLE DB documentation. For more information about Microsoft ActiveX® Data Objects (ADO) and ADO (Multidimensional) (ADO MD), see the ADO documentation.

See Also

MDX

SQL