TM1 Rule to Propagate Values Between Dimensions
Posted: Mon Mar 25, 2024 7:51 pm
Hello,
I'm seeking assistance with creating a TM1 rule to dynamically propagate values between dimensions in IBM TM1.
There are 2 dim Product & CPG, Half of Product dimension is in CPG.
For eg, Product dimension is,
'Total Company' parent of 'PC' and 'HC', 'PC' splits in 'CPG1' and 'CPG2', 'HC' splits in 'CPG3' and 'CPG4', and 'CPG1' splits in 'LE1' and 'LE2' and 'CPG2' splits in 'LE3' and 'LE4', 'CPG3' splits in 'LE5' and 'LE6', 'CPG4' splits in 'LE7' and 'LE8'.
For eg, CPG dimension is,
'Total Company' parent of 'PC' and 'HC', 'PC' splits in 'CPG1' and 'CPG2', 'HC' splits in 'CPG3' and 'CPG4'.
Objective:
My objective is to create a rule that automatically updates attributes in the Product dimension based on changes made at level 0 elements in the CPG dimension. Specifically, when a value ('Y') is entered at a level 0 element in the CPG dimension, I want this value to be propagated to specific leaf elements in the Product dimension that correspond to that CPG element.
For eg,
If you input 'Y' at the level 0 element 'CPG2' in the CPG dimension, you want this 'Y' value to be propagated to the leaf elements 'LE3' and 'LE4' in the Product dimension, which correspond to 'CPG2'.
Current Approach:
I've attempted to create a rule using the following logic:
['at_PBBU'] = S: If (DB('}ElementAttribute_CPG', !CPG, 'PPBU') @= 'Y', 'Y', ' ');
However, this rule doesn't seem to be achieving the desired outcome.
Request for Assistance:
I'm seeking guidance on how to create a rule that effectively achieves my objective. Additionally, if there's a better approach or alternative solution to accomplish this task, I'm open to suggestions.
Any help or insights would be greatly appreciated!
Thank you.
I'm seeking assistance with creating a TM1 rule to dynamically propagate values between dimensions in IBM TM1.
There are 2 dim Product & CPG, Half of Product dimension is in CPG.
For eg, Product dimension is,
'Total Company' parent of 'PC' and 'HC', 'PC' splits in 'CPG1' and 'CPG2', 'HC' splits in 'CPG3' and 'CPG4', and 'CPG1' splits in 'LE1' and 'LE2' and 'CPG2' splits in 'LE3' and 'LE4', 'CPG3' splits in 'LE5' and 'LE6', 'CPG4' splits in 'LE7' and 'LE8'.
For eg, CPG dimension is,
'Total Company' parent of 'PC' and 'HC', 'PC' splits in 'CPG1' and 'CPG2', 'HC' splits in 'CPG3' and 'CPG4'.
Objective:
My objective is to create a rule that automatically updates attributes in the Product dimension based on changes made at level 0 elements in the CPG dimension. Specifically, when a value ('Y') is entered at a level 0 element in the CPG dimension, I want this value to be propagated to specific leaf elements in the Product dimension that correspond to that CPG element.
For eg,
If you input 'Y' at the level 0 element 'CPG2' in the CPG dimension, you want this 'Y' value to be propagated to the leaf elements 'LE3' and 'LE4' in the Product dimension, which correspond to 'CPG2'.
Current Approach:
I've attempted to create a rule using the following logic:
['at_PBBU'] = S: If (DB('}ElementAttribute_CPG', !CPG, 'PPBU') @= 'Y', 'Y', ' ');
However, this rule doesn't seem to be achieving the desired outcome.
Request for Assistance:
I'm seeking guidance on how to create a rule that effectively achieves my objective. Additionally, if there's a better approach or alternative solution to accomplish this task, I'm open to suggestions.
Any help or insights would be greatly appreciated!
Thank you.