Problem with sort order in DRM and its solution

The very first time when you are building new hierarchy, DRM builds the hierarchy either in Alphabetical order or Numerical order.

However you are looking for hierarchy that should not follow either Alphabetical or Numerical order instead DRM should build the hierarchy the way input looks.

This can be done in two steps

Step 1: Create one derived property with the below conditions

Property Type : Derived

Data Type : Sort

Overridable : Uncheck (by default it is checked)

Parameters : PropValue(Core.ID)

Even though DRM follows Alphabetical or Numerical order it creates an ID based on the input file, so if you sort the hierarchy based on ID you will get the required structure.

Make sure the property should be mapped at least one property category.

Step 2: Open the Hierarchy level properties.

              Browse for System property category.

              Locate the Standard Hierarchy Sort label and browse for newly created property and assign.

Now your hierarchy structure will be in your required format.

But when you are creating an alternative hierarchy with defined set of members and pattern, the set is combination of Leaf and Limb members, in this case the above derived formula will not holds good because DRM builds the hierarchy in alphabetical order or numerical order.

Small changes in the system preferences will turn the hierarchy structure around.

Navigate to the System Preferences in Administer tab and open SortLimbsFirst.

Set the value to False and save the changes.

Happy learning and thanks for all who supported to write this post :)