I am using Mondrian version 3.1.5 but am experiencing the performance issue described in
http://jira.pentaho.com/browse/BISERVER-1818

This case says the issue has been fixed but I am still experiencing the severe performance issue. Can anyone familiar with this issue confirm if the issue is truly resolved ?

When I have Mondrian Roles set up in the schema I get repetetive SQL generated:

DEBUG [mondrian.sql] 407: SqlMemberSource.getMemberChildren: executing sql

...multiple times (12) for every member of a dimension (not restricted by the mondrian role) included in the analysis.

This winds up executing redundant sql, thousands of times

Can anyone provide any more information on this issue.

Thanks.