I was a little bit distracted by other issues, but now the methods for finding the last processed dates on per partition level are ready. I've uploaded the patch; you can find it under
. It would be great if you could review the code and integrate it into ASSP project.
The code should be pretty self-explanatory, just a couple of notes:
1. I've made several methods, so that one can find the last processed date in (all measure groups and all partitions) or (one specific measure group and all partitions) or (one specific partition). There
is also a possibility to specify the cube explicitly (otherwise the current one will be used).
2. If a dimension is processed with ProcessUpdate and no aggregations or indices are dropped, then the "last processed"-timestamps of partitions actually do not change, but the timestamps of the measure
groups do. I've added a parameter whether the timestamps of measure groups should be taken into account (default - true). So, the simplest version with no parameters will check all partitions in all measure groups in the current cube with "last processed"-timestamps
of the measure groups taken into account.
3. I've thoroughly tested the code for SSAS 2008 R2 (all overloads, invalid measure group name, invalid partition name etc.), but didn't test it for SSAS 2012 (though I do not expect anything to be different).