Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import hierarchy with sort based on file order, not alphabetical

Jeo123Jul 20 2020 — edited Jul 22 2020

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.

Comments

Post Details

Added on Jul 20 2020
#business-intelligence-applications, #hyperion-drm-analytical-master-data, #system-management-and-integration
5 comments
706 views
4 mentions