tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P206

Microsoft SQL Server 2008 R2 Unleashed- P206:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2044 CHAPTER 51 SQL Server 2008 Analysis Services Creating an OLAP Database Remember that an OLAP database is made up of data sources dimensions and cubes. A data source is simply a pointer to data somewhere such as via a Jet OLE DB provider an OLE DB provider SQL Native Client Microsoft Directory Services or even SSIS packages. You populate the data in your cube from the data source. Dimensions are constructed of columns from tables that you select to be used to build and filter data cubes. Cubes are combinations of dimensions whose intersections contain strategically significant measures of business performance such as quantities units amounts and so on. You need to identify the data sources from which your OLAP cube is to be based. Adding a Data Source To add data sources for a new database you simply right-click the Data Sources object in the Solution Explorer or select Project New Data Source in Visual Studio. The Data Source Wizard is then initiated. As mentioned earlier much of SSAS administration is wizard based. The Data Source Wizard starts with a prompt for you to select how to define the connection to a data source. You can use any existing connections or create new ones from this dialog. Figure shows these two options along with the data connection properties. If you have attached the CompSales database or any other database already you can easily create a new connection to this database for use in this example. FIGURE Defining a data source connection in the Data Source Wizard. Figure shows the Connection Manager dialog where you specify the provider to use for example Native OLE DB SQL Native Client the name of the database to connect to and the authentication method to use for the connection. You should go An OLAP Requirements Example CompSales International 2045 ahead and establish a connection to the CompSales database you just attached and click the Test Connection button in the lower-left corner to verify that it is valid. .