d/EPM Cloud MT - Hierarchy Listing Order

When selecting a hierarchy for a dimension in self service, Is there a way to change the order of the listing? I'm not sure what is driving the order currently. It doesn't appear to be alphabetically ordered and not in the same order as the hierarchies are organized in d/EPM Admin database structure.

Find more posts tagged with

Infor EPM Discussions

Comments

John Robson

Yes

In relational modelling you could/should add a column of type number called OrderPosition - the column name matters.

When you preview it in Dimension View you will I think (at least in the latest version) see the order you will see in Self Service.

christopherd

Thanks John I'll give your solution a try. I'm already using OrderPosition to order members within the same hierarchy of a dimension. I didn't even think about using it to affect the order of the hierarchies.

Quick Links

Developer Community
Infor OS Platform Forums
Hackathon
Developer Portal
Developer Newsletter

Copyright © 2025 Infor. All rights reserved.