Monday, April 11, 2011 1:19 PM
Can anybody help me in How to process partitions dynamically in Cube through SSIS packages(2008 R2)?
For Example: A cube has 2 MeasureGroup
- B012 Olap Cust Item Status_2010
- B012 Olap Cust Item Status_2011
The suggession required are:
Suppose we want only to process Partition ending with 2011 and regulate the partition to process with parameter.
How could I achieve this?
Please help ..any form of help will be thankfull.
Thanks, Tanmoy Santra
Monday, April 11, 2011 1:27 PM
Not sure whether this will be useful...but you can take a look.(the above link is sufficient)
For selective partition process you might have to form the XMLA dynamically and then use that XMLA for processing
Monday, April 18, 2011 12:06 PM
Thanks for the links.
I am using the XMLA to dynamically processing the cube.
I am facing the error that the " Processing Command contains the DDL that is not valid"
I think if I dont initialize the variable which contain the XMLA script it will not validate.So it is giving the error.But the initilaization space for a string is not enogh to accomodate a xmla script for processing.
Is there anything needed regarding this.
Thanks, Tanmoy Santra
Monday, April 18, 2011 12:53 PM
If you are using SSIS for processing partitions then you can simply use "Script Task" in your SSIS package and then write AMO code for processing partitions.
Check following sample code which I have build on adventureworks sample and it can be used for processing partitions with ID ending with 2001. you can modify sample AMO code as per your requirement.
Dim objServer As Server Dim objDatabase As Database Dim objCube As Cube Dim objMeasureGroup As MeasureGroup Dim objPartition As Partition objServer = New Server objServer.Connect("localhost") objDatabase = objServer.Databases("Adventure Works DW 2008") If objDatabase.Cubes.Count > 0 Then objCube = objDatabase.Cubes("Adventure Works") For Each objMeasureGroup In objCube.MeasureGroups For Each objPartition In objMeasureGroup.Partitions If objPartition.ID.Trim.Substring(objPartition.ID.Trim.Length - 4, 4) = "2001" Then objPartition.Process(ProcessType.ProcessFull) End If Next Next End If objServer.Disconnect()
- Marked As Answer by Challen FuModerator Tuesday, April 19, 2011 9:27 AM