I created a cube using schema workbench. I published the report in 'pentaho user console'. When I try to filter ID, It says: 'Oops. There was an error. Please try again, or contact your administrator.'
On the pentaho.log inside /opt/pentaho/server/biserver-ce/logs, I get below message:
Caused by: java.lang.RuntimeException: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
How can I get rid of this error message.