Before Administering Analysis Services
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.