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
