Is it possible to write a Validation to find the Root Node of the Hierarchy,
For E.g. If we have a three level hierarchy
Printer
Dot Matrix
T123
So is there a way I can check if my Root node value is Printer or not, because in Data Manager the value that is selected from the hierarchy drop down is the leaf node.
then using *Hierarchy..Name* expression will return the parent of selected child i.e. when your record contains Laser2 then the expression will return Laser, for Dot Matrix you will get Printer as an output.
You can first check this output by creating an assignment on any text field and then go for validations. For Validation use Hierarchy.. instead of Hierarchy..Name and dont write any thing manually.
Note: Hierarchy is the hierarchy table name and Name is the field present in hierarchy table.
MDM does not give us the option to traverse to the grandparent of the leaf node..
In the example that we have taken :
Printer
- Dot Matrix
- Laser
--Laser1
--Laser2
Here if we want to check if the Grandparent of Laser1 is Printer, this cannot be done using the simple Validation, because through validation also we can at max find the parent of the current node i.e. we can traverse till Laser (for Laser 1 leaf node).
Further we cannot use Laser as the node because in MDM we have to traverse completely through the last node and select it in Data Manager. So again we cannot search for Laser -> Parent.
The Work Around that I have used is :
I have created a new field and every time I import data I have mapped this field with the first Level Node and have put the Validation on this field.
Eg: The field name is Root Node, so everytime the data is imported, Level 1 is mapped to Root Node and so all the Root node values are imported in the Root Node field that we have created and everytime the Validation Runs on this Root Node field and accordingly the process follows.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.