Hi everyone. I'm using schema workbench to create a test cube and I saw the option to add the sql 'caption expression' in dimensions. So I tried to use a simple expression like
CONCAT(Customer.Name,' ',Customer.`Name 2`)
and it works ok, however if try to write a simple select statement like
SELECT Name from Customer WHERE No='1'
it doesn't, I get an error "Error Occurred While getting Resultset" in pentaho user console. Any suggestions what I am doing wrong here. Thanks in advance.