Calculation and Query Reference for Oracle Essbase MDX MDX Function List Left Left The MDX Left() function for Essbase returns a specified number of characters from the left side of the string. SyntaxLeft ( string ,length ) Parameters string Input string. length The number of characters to return from the left side of the input string. ExampleLeft ("Northwind", 5) returns North.