Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

Appendix CGraphical DDL Queries

This appendix demonstrates how to generate DDL queries graphically. Such queries are for creating and training data mining models. You can do this from Excel 2007/2010 or from BIDS. There are also a number of features in SSIS that help you create and train data mining models with little or no syntax involved. In this appendix, you get to see how it can be done in Excel 2007/2010, SSAS in BIDS, and SSIS in BIDS.

Key concepts Creating data mining models graphically, training data mining models graphically

DDL Queries

DDL queries were covered in Chapter 7 and involved a fair amount of reasonably complex DMX syntax. ...