Forum Stats

  • 3,824,768 Users
  • 2,260,416 Discussions
  • 7,896,309 Comments

Discussions

Import hierarchy with sort based on file order, not alphabetical

Jeo123
Jeo123 Member Posts: 515 Gold Badge

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.

Answers