Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

VI.3.3. Creating New Scripts

When working with SQL Server Analysis Services (SSAS) projects in SQL Server Management Studio (SSMS), you have the ability to create different types of scripts.

Using the tools within SSMS, you can generate Analysis Services Scripting Language (ASSL) scripts, or you can create your own DMX, MDX, or XMLA queries.

NOTE

The Analysis Services Scripting Language is described briefly in Book 6, Chapter 2. In short, it is an XML-based scripting language used to create and modify SQL Server Analysis objects.

VI.3.3.1. Generating ASSL scripts

One of the benefits of using SQL Server Management Studio is the ability to create new scripts easily from existing SQL Server Analysis Services projects. It's as easy as right-clicking the SSAS object you want to script and selecting the output target.

For example, Figure 3-5 shows how you can create an Analysis Services Scripting Language (ASSL) script for a mining structure. By right-clicking any object, you can generate a script to a New Query Editor Window, an external file, or the Clipboard so that you can paste the script into another document.

Figure VI.3-5. Generating an ASSL script.

Any of the objects within an SSAS project can be scripted by using this process. This includes the entire database, data sources, data source views, cubes, dimensions, measure groups, and data mining structures.

VI.3.3.2. Creating ...