How To Create XMLA Script For Cube Process Using SSMS

Following steps will explain “how to generate a XMLA Script for Cube process” using SQL Server Management Studio (SSMS).

1.       Open SQL Server Management Studio by clicking on the SSMS shortcut icon which located in the Start --> All Programs --> Microsoft SQL Server 2008 R2 --> SQL Server Management Studio.

See the given exhibit for reference (select any version whichever you installed)

2.       Click on the “Connect” button, which is available at Object Explorer, Choose “Analysis Services…” as shown Below

3.       Enter the server detail/credential you want to connect

4.       After you connected to the with proper server details, you can see the list of databases available on the server in Object Explorer Windows as shown below

5.       In Object Explorer, Select the cube which you need to process --> Right Click on “Process”

6.       Upon click on process, Following model dialog window will appear  --> Click on Script link

7.       Script link helps you create a script in 3 ways as listed in the exhibit

8.       I’ve selected the option to generate the output script on “New Query Window”, so it generated the script on New XMLA Script window as mentioned below:

Sample XMLA Script:-

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

  <Parallel>

    <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">

      <Object>

        <DatabaseID>Analysis Services Tutorial</DatabaseID>

      </Object>

      <Type>ProcessFull</Type>

      <WriteBackTableCreation>UseExisting</WriteBackTableCreation>

    </Process>

  </Parallel> 
</Batch>

Note: system will generate the script as per the input you provided on Process window in step 6

SQL Server 2012 RC0 Available for Download

Microsoft SQL Server 2012 Release Candidate (RC0) is now available for Download.

There are many highlights and stunning BI features available in SQL Server 2012.
If you evaluated the previous release SQL Server 2012 Community Technology Preview 3 (CTP3), then you might aware that “PowerPivot” now supports the features like,

• Hierarchies
• Multiple relationships between tables
• A measure grid to easily create, edits, and manages measures
• Key Performance Indicators (KPIs)
• New DAX functions (Time series, distinct count to name a few)
• Importing of binary large objects (BLOB)
• Etc.,

All the above listed features and more… in Analysis Services Database

• Row-level security
• Partitions and Direct Query mode
• Direct access to source system
• Etc.,

Other improvements:

• Upgraded SharePoint Components
• Separated setup and configuration strategy
• Project "Crescent" (now called Power View)
• And more…

Here are the highlights and product overview for SQL Server 2012 Release Candidate from Microsoft:

Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence.

SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence:

• Deliver required uptime and data protection with AlwaysOn
• Gain breakthrough & predictable performance with ColumnStore Index
• Help enable security and compliance with new User-defined Roles and Default Schema for Groups
• Enable rapid data discovery for deeper insights across the organization with ColumnStore Index
• Ensure more credible, consistent data with SSIS improvements, a Master Data Services add-in for Excel, and new Data Quality Services
• Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Data Tools for a unified dev experience across database, BI, and cloud functions

Download (Registration Recommended)
http://www.microsoft.com/download/en/registration-suggested.aspx?id=28145
 

Note: Registration takes only a few moments and allows Microsoft to provide you with the latest resources relevant to your interests, including service packs, security notices, and training.

Other References:

• Here is the link to the official SQL Server Team blog, on details of the release, http://blogs.technet.com/b/dataplatforminsider/archive/2011/11/17/sql-server-2012-release-candidate-is-now-available.aspx 
• You can learn about SQL Server 2012 and the latest editions that are coming.  The big news is that Microsoft is releasing a NEW Business Intelligence Edition.  Read More on SQL 2012 Editions here http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx