Skip to main content

I'm trying to create a hierarchy of GL accounts and the category they belong to. (i.e. Assets, Liabilities, Equity, Income Expenses).

However the Hierarchy is displaying alphabetically.  If it were to be sorted by the first GL account it's associated with, it would sort correctly since GL accounts are numbered in the proper sequence.

However, when I tell the Dimension, "Parent Category" (which is the Assets, Liabilities etc) to sort by Attribute Key, when I deploy I get an error saying it can't be used as an attribute because it is not related.

Is there a workaround to this?

Hi Mark.

 

Your hierarchy table could look like this

jdqJMG2ikDXTKT7ytw2phQ.png
 

And the dimension like this

 7eyPz9k4EOooQn-0EFFEow.png

ID is containing the child id of the parent child.

Sort By is a dimension level on the Parent child dimension.

 wxpZ5nbF6ZdkmjIwqhIS7Q.png

And contains the field you wish to sort by

 5k-Ol46lswEootbTgjJwXQ.png

Which here is the Sort Order field on the Parent Child table – giving this ‘lay out’. (The Account level is sorted by the account number)

 grBJolljtSXtp5SjOOm6jQ.png

Regards Jens Jørn Mikkelsen

Terms & ConditionsCookie settingsAccessibility statement