We are doing a custom analytical query based on a custom CDS which shows the GLAccounts. One of the demand is to have the GLAccount hierarchy available in the report but we weren't able to do that.
I see in standard queries that we can check the Hierarchy parameter on GLAccount field, but this option doesn't appear in the query builder which brings me to think that we missed something when creating the custom CDS.
I also didn't find any documentation on how to have a hierarchy available from a custom CDS into the Analytical Query builder.
I tried to add the propertiy Master Data View in the custom CDS but was blocked as the field is already in use in the query. Do I really have to remove it from the query (if not delete the query at all) to do an evolution on that field?
Any link / help on that subject is welcomed.