There is also a REST API in DV that let you execute queries (I believe it mostly takes a XML/JSON query instead of directly a LSQL query), but as far as I know, it isn't publicly documented so f…

And to answer your question: so that means whatever is published under the "semantic data model" approach would need to be published or made available as a "dataset"? No, just cal…

Hi @user13092632 , I maybe understand your question wrongly, but if you are asking how you can query your own subject areas built in your RPD and deployed in your OAC, then you can look at the good o…

You should look at the AGO function, that one will let you get the Amount for 2020 when on the 2021 year. And then, you can add a CASE WHEN to handle the case of the Amount existing already for that …

If EM works for what you need (you shouldn't be spending much time in there anyway), I wouldn't bother much… If you really want to try to get rid of that, you could try giving more memory t…