Material Group Hierarchy not showing up in custom analytical query

[HM25]

Hello All,

I'm facing a challenge and it will be very helpful if any of you can help me with the same.

The problem statement is: "We have defined a material group hierarchy in the Manage Global Hierarchy tile but it is not showing up in the Spend Analysis query. We need to ensure that when the user runs the Spend Analysis query, adds material group field in the row, they should get an option to go to hierarchy option, select a predefined hierarchy and the data should now be shown based on this hierarchy."

We have tried a few methods but none of them are working. The option to select hierarchy is not appearing. 

Please provide relevant solutions as soon as possible.