Sorry for the late response. Currently, I am unable to access the data source for some reason. Will check and update it once I try this.
One query that pops up is aggr will be executed at run time which can slow down the report ( I have around 50M records) , and aggr is not supported in the data load script. I am trying to create these tables in the data layer itself to improve performance.