TI to Replace Dynamic Subsets with Static Subsets
Dynamic subsets are always better when your dimension is changing frequently and you have to use a subset of that dimension in your cube view. But dynamic subsets consume considerable amount of memory. So it’s advisable that if possible, you should use static subsets to dynamic subsets.
TM1 consultant Rahul Parashar has submitted a TI process which can help you manage that in your model. You can keep a list of all the dynamic subsets of your model in a cube and a TI created by him can convert all such subsets to static subsets in single go. How cool is that!
So from next time if your dimension gets updated, just run the TI process again to update your static subsets with new items.
Here are the details of TI process.
TI to Replace Dynamic Subsets with Static Subsets:
Dimensions: }DynamicSubsetsParameters, }DynamicSubsetsSerialNumber
Just keep a list of all your dynamic subsets, their dimensions, and their MDX Expressions in the above cube and run the TI.
Subscribe to our site to get the TI process.