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"> 
<SQL dialect="generic">
end )

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