CODEWITHSUNDEEP
ssisssasssis-2012xmla
user14861333
user14861333

Reputation:

Process Add XMLA measure group SSIS

Is it possible to execute process add on measure cube in SSIS? I tried to look for the XMLA script but I don't see anything for it. I need to run the script several times with different where parameter (Add processing will need to be added to for loop container)

Upvotes: 0

Views: 171

Answers (1)

Brenton
Brenton

Reputation: 444

The Analysis Services Processing Task allows you to process Analysis services cubes, and it should allow you to specify Process Add in the processing options.

If that doesn't work for your scenario, there is also the Analysis Services Execute DDL Task which allows you to execute raw XMLA commands, so you could construct and execute the XMLA to do the processing you require.

Upvotes: 1

Related Questions