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:
Cube: }DynamicSubsets
Dimensions: }DynamicSubsetsParameters, }DynamicSubsetsSerialNumber
Process: SubsetsDynamicToStatic
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.
Loading ...
Dear all
I’m an beginner in tm1 and i’m interested by the ti script to replace dynamic subset to static
Thank you
Hello,
I have a TI process that creates a static subset by indexing through the elemtns in the dynamic subset. It is very slow. Is Rahul’s process faster?
Why don’t you download the TI and see for yourself? Shall we send the TI to you? Also, Rahul’s TI is a generalized plun n play component so add it to your project and you’re good to go. It manages all dynamic subsets using a cube view which stores the dynamic subsets information.
yes, please send a copy of the TI to my e-mail. Was there a link to it on the web? I didn’t see it.
Admin, Can you please send me the TI to my email id. Thanks in advance
Can you please send the TI process to my email id.
Thanks in advance.
pls send me the ti for the above.
Hi,
Can you please share the TI process to create subsets.
Can you also please share how a plug n play component is created?
thanks.
Please send the dynamic to static TI process to my email. Thanks!
Could you please send me the TI process?
Hi,
Can you please share/email the TI process to create subsets.
thanks.
Sent to all
I need the TI Process for the Dynamic Subsets
Hi! Can you please email me the T1 process? Thank you very much!
Please send me the TI. Thanks!
Hi , Can you please send TI process to my mail id please ? Also I have a question how dynamic subsets consume more memory than a static once ?
Hi,
I have the TI process created by Rahul but i didn’t get how to create the “}DynamicSubsets” control cube with it’s control dimensions.
what’s the problem in creating it? You just need to add all the files to your TM1 data directory and restart your server.
Dear Admin,
Can you share the TI process with me as well please?
Also we would really appreciate if you can post some more such interesting details as well.
Thanks
Dear Admin,
Can you share the TI process with me as well please?
Thanks
hola que tal, me puedes mandar el proceso TI.
Gracias
Hi, Can you please email me the T1 process?.
Thank you
Bonjour, pouvez-vous envoyer le processus TI à mon identifiant mail s’il vous plaît?
pls send me the ti for the above.