- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
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
it is not as expected. The data in Import file is Period hierarchy
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