I am beginner in using penthao mondrian, I am trying to learn to translate the patterns in the XML file under Jpivot.
I have a small problem, I want to run queries like :
HTML Code:
level name="Nom" type="String" uniqueMembers="true"> 
<KeyExpression>
<SQL dialect="generic">
(case
when CLIENT.ADRESSE = "Tours" then CLIENT.NOM
end )
</SQL>
</KeyExpression>
</SPAN>

I want to use <SQL dialect="mysql"> putting a Select From where but does not work, I am forced to go through the dialect generic.
Have you an example of an SQL dialect form = "mysql"?
May be i have a wrong syntax.

Thank you