Export (0) Print
Expand All

Before Administering Analysis Services

SQL Server 2000

Before you begin administering Microsoft® SQL Server™ 2000 Analysis Services, prepare the data warehouse from which you will create cubes or data mining models. Also, if you are planning to specify data sources that are accessed through ODBC drivers, create system data source names (DSNs) for these databases.

Preparing the Data Warehouse

Several objects in Analysis Services are created from data in a data warehouse: cubes, partitions, dimensions, and data mining models. The data warehouse from which an object is created is specified in the data source of the object. For more information about data sources, see Data Sources.

Before you create these objects, prepare the data warehouse so that the objects can be efficiently created and maintained. For more information about the specific actions required to prepare the data warehouse, see OLAP and Data Warehouses.

Defining Data Sources in the ODBC Data Source Administrator

Analysis Services supports OLE DB and ODBC data sources. If you are using only OLE DB data sources as input to Analysis Services, you do not need to use the ODBC Data Source Administrator.

If you are planning to use the Microsoft OLE DB Provider for ODBC drivers for connections to ODBC data sources, before you start Analysis Manager, ensure that all of these ODBC data sources are defined as system DSNs in the ODBC Data Source Administrator.

Note  Remote administrators of Analysis Services must also define the same data sources on their computers.

See Also

Specifying Data Sources

© 2016 Microsoft