Forum Stats

  • 3,758,122 Users
  • 2,251,336 Discussions
  • 7,870,040 Comments

Discussions

How to handle the Sort order in DRM.

Ques: After Importing the metadata file members are sorted in Alphabetical order not in the order of Import file.

Answer: Like we imported the file and the member or Period hierarchy are Q1, Jan, Feb, Mar.

After load if we are checking the member it is coming as Period hierarchy

Q1->

Feb

Jan

Mar.

it is not as expected. The data in Import file is Period hierarchy

Q1->

Jan

Feb

Mar.

To handle the problem we have to follow the below steps.

First create a cusotm property and assign it to the Core.StandardHierSort.

Please follow the below screenshot.

Create a Custom proeprty Sort_ID

Assign Custom.Sort_ID as default value to Core.StandardHierSort


Tagged: