Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

Appendix BGraphical Prediction Queries

You can also generate Prediction queries graphically. This appendix shows how to do so in SSMS, SSRS, SSIS, SSAS, and Excel 2007/2010.

Key concepts Graphically generating Prediction queries

Prediction Queries

In Chapters 3 through 6, you saw how to write DMX for Prediction queries. You can also generate most of those queries graphically and then view the underlying DMX. This saves on typing and helps eliminate syntax errors. In addition, it’s a good way to learn many of the intricacies of DMX syntax for Prediction queries. Nearly all of the graphical tools available use the Prediction Query Builder. This ...