EZ q, can you script out the XMLA to Process Full? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

EZ q, can you script out the XMLA to Process Full?

Author

Topic

tybaltzeke
Starting Member

28 Posts

Posted - 2010-04-13 : 12:01:05

i apologize for this beginner's question

i am seeing some discrepancies between processing a cube in ssms (much longer) and processing it in BIDS.

Question 1. How do i script out the XMLA for Process Full on the Cube (i dont see the option).

Question 2. The XMLA i'm running in SSMS (see below, its inherited) doesnt refer to the cube, only the database. Could this be the reason its taking longer? how do can i modify it to make sure its only processing the cube i want

Question 3. i saw the cube take the longer time in BIDS **ONCE** but now i unfortunately cant reproduce it. at that time, all of the dimensions were reprocessed. when takes the shorter time, only the FACT table is processed. what would make it process the dimensions (again)?

savior faire
Posting Yak Master

194 Posts

Posted - 2010-04-14 : 19:34:04

1.) A process full is actually two processes. The first process is Process Data, then Process Index.

2.) Your xmla script says process database because when it was created, the individual created it by right clicking the SSAS DB and selecting "Process", then saving the script. Here is an xmla to process a cube:

<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">
<Object>
<DatabaseID>Analysis Services Tutorial</DatabaseID>
<CubeID>Adventure Works Tutorial Cube</CubeID> </Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>

3.) I can't think of a response for item 3.
hope this helps.

______________________________________________
Talk sense to a fool and he calls you foolish.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources