Hi. I have an Analaysis Services (2005) cube with four dimensions and one fact table (with three partitions - 2006,2007,2008) for which I need to create an SSIS package to process. I only want to process one of the three partitions (2008) - the previous two years should remain unchanged. This is what I have currently in the Analysis Services Processing Task under Processing configuration: - An object for each of the dimensions with "Process Full."- An object for the 2008 partition with "Process Full." (Note - Under Process Options, I see only Process Default, Process Full, Unprocess, and Process Data for dimensions and partitions). Batch settings are:- Processing order: Sequential- Transaction mode: All in one transaction- Dimension errors: Ignore errors- Process affected objects: Do not process When I execute the package, the cube loses the 2006 and 2007 data. I am assuming that I have an issue with the Process Option or the Batch Settings, and I would appreciate any guidance! Thanks,Marianne

Do you mean the partitions are there with no data? or the partitions are missing? Could be be that the partitions where marked as unprocessed?

The partitions are still there, but when I browse the cube, there is only data for 2008. Where/how would I see if the partitions are marked as unprocessed? (sorry - very new to MSAS) If I process from within Analysis Services (instead of from SSIS), the data is there for all years. Thanks, Marianne

That would be evident, you will see a message telling you you have to process the it before. Are you sure data for those partitions was there before processing the cube? Check that you don't have any task/component that somehow drops/recreates those 2 partitions. You can also try capturing the SSAS DB activity using SQL profiler. That way you could try to spot any suspicious xml command that may be deleting that data. If the problem persists; try asking in the SSAS forum.

Yes, the data was definitely there. I browsed the cube before I executed the package, and it had data from 1/1/2006 through 4/2/2008. I executed the package in order to update the dimensions and toget thefact data up-to-date. When I browsed the cube again, I had data from 1/1/2008 through 4/8/2008. Then I re-processed from within VisualStudio/Analysis Services, and got all my data back (1/1/2006 - 4/8/2008). The only item in my SSIS package is the Analysis Services Processing Task. I debated which forum to post in, and decided to post the question here since it's the SSIS part that is giving me the issue. The cube works fine; I'm just trying to schedule the daily processing. I can definitely try the Analysis Services forum, as well. Thanks, Marianne

Just change the dimensions Process option to "Process Update". and it will work.

Hi, If you run Process update for dimension, you need to run "Process Indexes" on cube. Other wise indexes will not be created on the cube. best regards, SengwaBest regards, Sengwa