|
Hi all,
I have an SSAS cube with 4 measure groups and some 15 dimension tables, of which i created 2 partitions for one of the measure groups based on the year(2009,2010),initially i deployed and processed the cube and got correct results in the cube as both partitions gets processed there.Later i created a package in SSIS 2005 to process the cube, and in that i have selected only the current year partition(as last year partition has huge data i ommitted that from selection),all dimension tables,the remaining three measure groups and executed the task.But this time i got data only for the current partition,last year's data is gone from the cube.So how to get both partitions data even though we select only one partition.
Thanks
Sandeep
|