IBM Cognos TM1 Tutorial : TI Process - How to create dynamic subset

How to create dynamic subset in TM1

[chittikeeru]

How to add SQL query in ti process to load data in existing cube using ti process

[chittikeeru]

Different syntaxs using in prolog tab how to write code how to change the code to add two more extra dimensions using ti process

[mvlogsyt]

Wrong video... The title say TI process and u have used MDX

[almondeastland]

Bit disappointed. I already know how to create a dynamic subset in the subset editor; I was looking for how to write a TI Process that can create a dynamic subset. The title of this video shouldn't refer to a TI Process if it has nothing to do with TI Processes.

Also, it is my understanding that it is best practice to define the subset basis to avoid unexpected results. So instead of {TM1DRILLDOWNMEMBER( { TM1SubsetBasis() }, ALL, RECURSIVE )}, the code should be modified to something like {TM1DRILLDOWNMEMBER( {[account2].[Marketing] }, ALL, RECURSIVE )}