LEFT

Description:

This function is used to return a string containing the specified length from the left side of a specified string expression.

Syntax:

LEFT(String_Expression, Length)

Return Type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
String_Expression	It is a valid MDX expression that returns a string scalar value on which LEFT function is to be applied.
Length	It is a valid MDX expression that returns a numeric scalar value that specifies the length of string to be returned.

Example:

WITH 
    MEMBER [Measures].[First 3 Chars] AS
        Left([Product].[Product].CurrentMember.Name, 3)
SELECT 
    {[Measures].[First 3 Chars]} ON COLUMNS,
    [Product].[Product].[Product].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]