Import hierarchy with sort based on file order, not alphabetical

Jeo123

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:

1. 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
2. Changed the Core.SortOrder to no longer be hidden
3. 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.

Krishna Chukkaluru

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

ManojPavan

https://community.oracle.com/tech/apps-infra/discussion/4339680/import-hierarchy-with-sort-based-on-file-order-not-alphabetical

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

Simran

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.

PiyushmanitiwariIBM

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.