Working with the DMX Language

If your business requirements call for custom client development using the data-mining API, you can begin to familiarize yourself with the DMX language by reviewing the supplied templates in SSMS. As with creating an SSAS query, you first connect to SSAS in SSMS, display the Template Explorer, and then click the DMX node to view and work with the included templates. Figure 14–21 shows the included DMX templates.

They include Model Content (which allows simple querying of model data and metadata, such as return model attributes), Model Management (which allows for administration, such as create, rename, and export model), and Prediction Queries (which allows use of model content in conjunction with other data using ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.