Chapter VI.3. Data Mining and Maintaining Analysis Services Objects
The majority of your work with SQL Server Analysis Server (SSAS) projects is within the Business Intelligence Development Studio (BIDS). However, you can also use the SQL Server Management Studio (SSMS) to work with your SSAS objects.
SSMS provides access to the tools you use to create ASSL scripts easily for your objects. You can use these scripts for archives, or as templates to create additional objects using ASSL. You can also write DMX, MDX, or XMLA scripts against the SSAS project to retrieve project data. Of course, you can also use the SSMS graphical user interface to view and modify object properties.
If you don't know what all these acronyms mean — ASSL, DMX, MDX, and XMLA — don't worry. You find out about them in this chapter.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.
