tailieunhanh - MASTERING SQL SERVER 2000- P22

Tham khảo tài liệu 'mastering sql server 2000- p22', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 1070 CHAPTER 28 ANALYSIS SERVICES FIGURE Selecting training data in the Mining Model Wizard Click Next to move to the Create Dimension and Virtual Cube panel. This panel allows you to capture the results of the data-mining process for further analysis. In this example you ll name the dimension Customer Analysis and the virtual cube Mined Cube. A virtual cube you ll recall is a cube that contains information from other cubes in this case the Sales_1998 cube and the mined data. Click Next to move to the finish panel of the Mining Model Wizard. Here you must assign a name to the model. You ll choose Customer Analysis Model as a name. Select Save and Process Now and click Finish to create the data-mining model. After the model has been processed you can right-click it in Analysis Manager and choose Browse to see the results of the analysis. Figure shows a datamining model open in the Data Mining Model Browser. The different shadings used in the model indicate how strongly the input data correlates with the factor being predicted. Analysis Services automatically arranges factors to show you the most significant ones first. In this particular model whether the customer had better than a partial high school education is the most significant factor in predicting yearly income. You can use the Content Navigator in the upper-right-hand corner of the Browser to drill down to increasingly less important factors. OLAP FROM THE CLIENT 1071 Browsing a data-mining model FIGURE OLAP from the Client So far all of the OLAP we ve looked at has been done directly at a server running Microsoft SQL Server Analysis Services. However there are alternatives that will retrieve OLAP information from a client. In this section we ll show you two of these alternatives. The first is an older technique that doesn t use Analysis Services at all T-SQL includes two operators CUBE and ROLLUP that let you perform some OLAP analysis without any software beyond SQL Server itself. The .