[JasperServer not refreshing data on change in Database]

I dont think so that the issue is with the database connection because when i flush the OLAP cache from the server setting the the changes are being reflected although I have already disabled the cache option.Are there any specific settings for Jasperserver enviroment as I am just configuring the datasource with the connection url?

[Drill Down Not properly working in AddHoc view for Parent Child Hierarchy]

For Parent Child Hierarchy Add-Hoc view is not showing appropriate drill down. It is working fine with OLAP view but same functionality is working wierd in add-Hoc view. This is in reference to the HR Cube of employe supervisor Hierarchy. Apparently it looks fine but the drill down, while clicking on '+'  arrows doesn't work fine. Kindly guide how to achive the same functionality in Add-Hoc as provided in OLAP View

I have attached the Ad-Hoc view of the Cube

[JasperServer not refreshing data on change in Database]

Jasper Server is not refreshing the data on change in database for both OLAP and ADHOC  View. The result remains the same even if the data in the database is changed.The schema needs to be reloaded in order to refresh the new changes.Can you please help me a way out in which I dont need to update schema again and again.