PDA

View Full Version : Request SQL



Kikou
06-23-2009, 11:26 AM
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 :

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