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

Reply


Terms & ConditionsCookie settings