How do we get summary update with filtered members (Jasper OLAP)

[msuryadevara]

Jasper OLAP gives global summary of a Dimension for All Members and Global summaries for Level members. Summary of members are not reflecting the filtered children. In the search someone mentioned 

to use sql view in the cube schema. How do we do it? Dynamic summary values are very important to my sponsor and after spending hours to searching for solution I am posting this question. Hope Jaspersoft

should provide some documentation for this! BTW, I have level members refering children from different levels. I am using averages of calculated measures.