Process a SSAS cube's dimension by a T-SQL query

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 2005 Forums

SQL Server Administration (2005)

Process a SSAS cube's dimension by a T-SQL query

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-07-25 : 22:48:28

Hi All,

HI,

I need to process a SSAS 2005 cube's (full one cube at a time)by a T-SQL query, using a SQL agent job and need to schedule to run everyday on SQL server 2005 enter.edition.

How can this be done.

Thanks,
Gangadhara MS
SQL Developer and DBA

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-25 : 23:17:15

We use an XMLA script.

See this article

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-07-26 : 03:47:25

I am using this query to process SSAS 2005 cubes inside the Job Agent.

<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">
<Object>
<DatabaseID>SFE</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>

Thanks,
Gangadhara MS
SQL Developer and DBA

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-26 : 09:43:07

That's what we do too.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources