In Planning Analytics, you can change the weights of an element in a dimension several ways. You can do it manually, however, we have found that re-running an associated TI process sometimes wipes any element weight changes. Therefore, we looked to create the action via a process instead.
To begin, we add a column to the .CSV file that builds the chart of accounts dimension. This column is named ‘Weight Override’. We filled it in with -1 where we wanted the subtotal to subtract the number. We set it to ‘String’ and ‘Other’. On the metadata tab below autogenerated section, we then wrote the code as follows:
#For those which have the weight override column populated, delete it from it’s parent and re-insert it with the override column weight.
IF(vWeightOverride@<>”);
#Convert the weight override column to a numeric value as its currently set as a string
vWeightNumeric=Numbr(vWeightOverride);
DimensionElementComponentDelete(‘CoA PLC’,vParent,vChildConv);
DIMENSIONELEMENTCOMPONENTADD(‘CoA PLC’,vParent,vChildConv,vWeightNumeric);
