Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

Chapter 5Prediction and Cluster Queries with Clustering

Mining models based on the Clustering algorithm may or may not have a predictable column—both varieties of models are explored in this chapter. A cluster model with a predictable column (for example, Bike Buyer) supports Prediction queries (for example, using the Predict() function). All cluster models support a range of functions that are specific to clusters (for example, the Cluster() function)—I have called these Cluster queries to distinguish them from Prediction queries. This chapter shows you how to perform Prediction and Cluster queries against models based on the Clustering algorithm. Cluster queries are useful for profiling and anomaly detection. Prediction queries are useful ...