Getting started with Automation of Analysis Services Objects
i working in ssas 2005 past few months.
at present, have requirement automate processing of cube using ssas. can able using ssis, requirement in such way should use ssas environment automate processing of cube after etl load.
i had gone through link, http://msdn.microsoft.com/en-us/library/ms124924.aspx, conveys stuffs amo,xmla,assl,etc.
from above tutorial link,i got through xmla, can able automate cube processing. couldn't concept of how best it. since there no walkthrough of automating alnalysis services object cube, dimension etc provided in above link.
it convenient me, if know how automate processing of cube using ssas. kindly key down valuable suggestions.
thank
sahul
"how automate processing of cube using ssas .." - not sure how define "only ssas", have looked @ ascmd utility?
readme ascmd command-line utility sample
...
scenarios
the following scenarios give examples of using ascmd command-line utility.
processing partition third-party toola database administrator must process partitions , dimensions part of nightly extract, transform, , load (etl) process. etl tool not sql server tool , database administrator cannot use sql server agent’s built-in support of xmla scripts or run sql server 2005 integration services (ssis) package. database administrator wants automated solution uses third-party tool. solution command-line utility run xmla script. utility called third-party tool. database administrator downloads , compiles ascmd command-line utility sample. after compilation, database administrator can use ascmd command-line utility execute xmla scripts process partitions , dimensions. backing olap database third-party toolanother database administrator @ same company required automate back-up of analysis services database. again, because scheduling software company using not sql server tool, task has run command line. database administrator generates appropriate xmla script (using sql server management studio). then, third-party scheduling software uses ascmd command-line utility run xmla script backup olap database. using xmla during installationa developer independent software vendor required integrate execution of xmla script directly installation of firm's product. developer must run xmla script , retrieve status (and trace events) know analysis services database created correctly. developer can using ascmd command-line utility.
SQL Server > SQL Server Analysis Services
Comments
Post a Comment