PDA

View Full Version : MDX error because no results



remys
11-30-2009, 10:19 AM
Hello,

I don't manage to execute xaction based on MDX whith Pentaho 3.1 when it doesn't return any row. It seems to be OK when there are some results.
Here is my error message :



java.lang.IllegalArgumentException: Cannot format given Object as a Number at java.text.DecimalFormat.format(Unknown Source)

at java.text.Format.format(Unknown Source)



It is maybe because of a complex formula used in this report see below :



INT(MOD([dureeAcdMoyTotal];3600)/60)



I have to convert a number in second to string format like HH:Mn:ss and i can't use the SEC_TO_TIME sql order because it is in MDX.


Does anyone has an idea about that kind of problem ?

remys
11-30-2009, 10:34 AM
I really believe that it's because I select an entry that doesn't exists in my mondrian cube. How can I prevent it ?
Thanks for your help.