Pentaho Analysis - Mondrian

Problem with the MID function getting last character in a string.