Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Import hierarchy with sort based on file order, not alphabetical

I've seen several questions along this topic, but most are from years ago(prior versions) and don't always end with clear conclusions.
I'm trying to import a dimension and have the order remain based on the order in the import file. For a simple example, let's narrow the focus down to the Time Period dimension. Under Q1, I have them listed as Jan, Feb, Mar, but the default is causing them to go to Feb, Jan, Mar.
Steps so far:
- Changed the default property for Core.StandardHierSort to be Core.SortOrder so that the hierarchy uses the Core.SortOrder even when it isn't imported
- Changed the Core.SortOrder to no longer be hidden
- Checked the box on Import>Styles to sort and use the Core.SortOrder
From what I've read, I thought that should work, but we're getting an error saying "Relationship sort property definition not found for Property: . Relationship sort property population aborted." which lists twice and then the sort order remains as the default 0, which causes it to alphabatize.
Any suggestions on how to get this working?
We're just getting DRM started as a result of an 11.2 upgrade in the works.
Answers
-
It should work with the above steps. Check below the simple import of Q1 hierarchy . Please check if you are doing something different.
Select Sort order property to populate in your import
Nodes are loaded with sort order values populated. But the nodes are sorted alphabetically under Q1.
Update the hierarchy property "Standard Hierarchy Sort" with Core.SortOrder and save it
Now you can see the nodes under Q1 are sorted by sort order
Regards,
Krishna C
-
Hello,
I am getting the same error while upgrading from 11.1.2.4 to 11.2.3. Are you able to resolve this issue?
Thanks,
Manoj
-
HI Manoj,
Even I am getting this error in 11.2.3. Are you able to resolve this issue?
Could you please let me know what did you do to resolve this or is there any workaround for this?
Thanks in advance.
-
Hi @Jeo123 /@User_MFSTW /@Simran ,
To resolve the issue you have to create a custom property and assign that property to StandardHierSort. Pleae find the below screen shot for reference.
First create a custom property
Now assign this id to Standard Hierarchy Sort
Hope this helps.