Data Mining - Professional SQL Server Analysis Services 2005 with MDX - page 752

Figure 14-19
You were able to predict the bike buyer value for the input case table using
the designer. The designer creates a query that retrieves the predicted data
from Analysis Services. The query language used to retrieve predicted results
from mining models is called DMX, which stands for Data Mining Extensions.
The DMX language is specified in the OLEDB specification for data mining.
The DMX language is similar to SQL and contains statements for data defini-
tion and data manipulation. The data definition language includes statements
for model creation, and the data manipulation language contains statements
for training the model, which includes inserting data into the model and re-
trieving prediction results from it. Just as SQL language has a SELECT state-
ment to retrieve data from a relational database, DMX has a SELECT state-
ment to retrieve data from mining models. The DMX SELECT statement has
several variations based on the nature of the results being retrieved. For de-
tailed information on the data definition language and data manipulation lan-
guage for data mining, please refer to the documentation of Analysis Services
2005.
Click the icon that you used to switch between design and result view (shown
in Figure 14-19 ) and select the Query option. You can see the following DMX
query contained in the query window pane which is generated by the query
designer to retrieve prediction results.
SELECT
t.[CustomerKey],