Skip to Content
0
Sep 11, 2023 at 07:49 PM

Datasphere: Analytic Model - Level Hierarchy issue

206 Views

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:

image.png

Any suggestions would be appreciated.

Thanks all!

Cal

Attachments

image.png (16.6 kB)