Product:
TM1
Microsoft Windows 2019 server
Issue:
How do i skip elements in a list/view in the data tab from a subset?
Solution:
If you have a subset named “DonaldsCoffe” that contain the stores-name that you want not to be transferred used in your data tab, in the TM1 TI process.
Use below statement to check if the element exist in the subset, and if it does skip that data.
IF ( DIMIX ('DonaldsCoffe', vElementName) <> 0);
Itemskip;
ENDIF;
In case you use =0 in above IF statement, that is that you will skip all elements that are not in the list.
DIMIX returns the position of the element in the subset list. 0 (zero) means the element is not in the list.
|
Operator |
Meaning |
|---|---|
|
> |
Greater than |
|
< |
Less than |
|
>= |
Greater than or equal to |
|
<= |
Less than or equal to |
|
= |
Equal to |
|
<> |
Not equal to |
To compare two string values, insert the @ symbol before the comparison operator, as in the following example:
IF (‘A’ @= ‘B’,0,1) yields the number 1.
More information:
https://www.tm1forum.com/viewtopic.php?t=15927
https://www.tm1forum.com/viewtopic.php?t=11902
https://quebit.com/askquebit/IBM/ibm-planning-analytics-dimix-function-when-and-how-to-use-it/
https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=functions-dimix