Report Portal

SSIS - Process Cube with XMLA and Analysis Services DDL

Generating XMLA Script and data from Cube. What I was looking to do, was to use XMLA and the Analysis Services Execute DDL Task in SSIS to dynamically process just a required partition that has already been created in SQL Server Analysis Services (SSAS). I found that doing this in SSIS was a quick and easy way in order to get my data processed.

Read more...

Tags: amo, process, ssis, script

 

2007-2015 VidasSoft Systems Inc.