Find a specific parent of the node
We are trying to add a validation rule in the entity dimension, which must apply to a specific section of the hierarchy and not the whole dimension.
We have multiple hierarchies in the entity dimension. The hierarchy, which is created under the parent CC_TCCC, is getting its members from the hierarchy viewpoint of the FCGL cost centre segment using the subscription. We have also enabled the prefix CC_ for the entity dimension.
The issue we have observed is if you manually add or import a member under the hierarchy of the parent CC_TCCC, then it allows you to create a member without any prefix. To stop this, we want to create a custom validation rule which will evaluate the node name under the hierarchy of the parent CC_TCCC and prevent the addition of any node that does not start with the word CC_.