Hi Akansh, The OBIEE physical query is generating in different way. Could you specify what all database feature you are thinking of? Regards, Avinash Sharma

Hi Cesar, Thanks for the reply. The RPD is same in both the environments. So the connection pool and security is in sync. This is basically due to a Ago column which we are using. Generally obiee generates single query with subqueries pointing one to the selected month and one to the ago month. This is happening on Pre…