To Process SSAS 2008 Database
<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>Mercury_HelpDesk</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
To Process SSAS 2005 Database
<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">
<Object>
<DatabaseID>CIT Global WareHouse</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
XMLA Script to Process cube through variable supplied
"<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>"+ @[User::CubeDatabase] +"</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>"
XMLA Script to Process cube through variable supplied
"<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>"+ @[User::CubeDatabase] +"</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>"
No comments:
Post a Comment