SSIS approach to handle Inferred Members - Mohit Nayyar...
Selective Cube Measure Groups processing using “Analysis Services Processing Task” in SSIS
Sometime its not feasible to process the full cube, so it makes sense to only process the selective measure group in the cube.
This is especially true when you have really big cube which takes time to process and sometime we just need to load data for only few business metrics.
...
Recently I found this issue of deadlock variables in SSIS and finally made two solutions 1. Instead of declaring variables in Script properties ( ReadOnlyVariables / ReadWriteVariables ), better to make use of Dts.VariableDispenser.LockForRead / Dts.VariableDispenser...