First, let me ask if I am correct in understanding that while fact tables can be partitioned, a drillthrough dimension cannot Thus, a drillthrough dimension must span the entire fact table
My users both want one to two years of info in the cube, and also want drillthrough. We have been able to persuade them to accept only a month or two of drillthrough.
Unfortunately, it appears that this is not doable.