Creating Adobe views in Denodo

Hi all,

We have connected to Adobe analytics via an API using denodo and have retrieved the metrics and dimensions. what we want to do is replicate front end reporting in denodo by creating views based on the logic of the front end reports. I've extracted the JSON query but the structure of this is in id strings that don't match the objects we can see in denodo. Has anyone done anything similar?

Thanks