All,

Is it possible to use DTS with vbscript or other dts objects to dynamically change the olap cube to point to a different partition ( assume that the cube has 4 partitions)

or are there any other means by which this can be done?

any help/suggestions appreciated