Welcome, Guest
Please Login or Register.    Lost Password?

Processing partitions and dimensions in SSIS 2005
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Processing partitions and dimensions in SSIS 2005
#1713
Processing partitions and dimensions in SSIS 2005 1 Month ago Karma: 0
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
sandeep
Fresh Boarder
Posts: 8
graphgraph
Points: 34
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: VidasMatelis, dgosbell