LEFT

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

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]