Hi experts,
I'm wondering if anyone has any experience or guidance around Level Based Hierarchies within Datasphere - specifically for consumption within an Analytic Model.
I'm aware of how to create a level hierarchy within the Data Builder - Table screen - but accessing the hierarchy post association in my Analytic Model gives me the below error:
The query executed with errors. Caught exception : exception 42201: Column not found : aSrcName=, ([Column country/!EMPTY (unknown0.0.0) Aggregation: 0]) in view
Is there a way to create and use Level Hierarchies in a graphical / SQL view? I can get parent child hierarchies working fine this way but they won't work for my scenario.
I tried to get creative with the below approach but that gave an even bigger error:

Any suggestions would be appreciated.
Thanks all!
Cal