Process Cube using SSIS
Hi! I want to process cube using SSIS package. I havea dimenaions and partitions in cube. I want to process dimensions first and then partitions. I used the 'Analysis services processing task' to process the cube. My problem occurs when I added the objects in objects list to be processed. I added all the dimension first as I wanted them to be processed first. and then added partitions. When I added partitions it appears in the middle of the dimensions I added earlier. and I am not able to scroll it down to the end of the objects list (after all the dimensions which I have added ). When I check the Processing order just after object list dialog box(in Batch setting summary), it indicates 'Sequential'. So, when I process the cube, would it process some of the dimension first , then partitions ,and rest of the dimensions?? My goal is to process all dimensions first and then partitions. How can I do that? I would appreciate your reply. Thanks,
March 11th, 2011 3:55pm

You may have to re-create the Task entirely to get it to process in the order you wish. That, or start to issue the process command from SSMS, but instead of processing, use the "Save Script" button to extract the XMLA command. Open the properties window for the AS Processing Task (F4), and paste the XMLA into the "ProcessingCommands" property. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 5:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics