@Nidhi Chhajed , this is expected. You WON'T be able to add new columns from this interface… or any interface at all. If you need an additional column, you have to add it to the query, no way around it, otherwise we wouldn't need the query builder.

reposted a new V4 version supporting up to 10 logical SQLs, i had to default it to INNER JOIN to keep it simple.

I concur, this is definitely comming handy in later stages of implementation. Usually the way subject areas work gives limited results and obliges us to combine 2 or more different subject areas, and even sometimes do 2 or more analysis and combine them. Having a LSQL easy builder would be extremely useful.

hey Jag, I havent dwelled into that yet. If I manage to know how a query would look like i can probably adjust the parser accordingly.

Thank you for the feedback. Likely if I had an Apex creation/edition permission somehow i'd definitely spend the time studying it. Obviously having this somewhat directly in OTBI would be awesome instead of the current join feature that actually does not work. When it comes to formating, that could be a next step for that…