LEN

Description:

This function is used to return the number of characters of the specified string expression.

Syntax:

LEN(String_Expression)

Return type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
String_Expression	It is a valid MDX expression that returns a string scalar value on which LEN function is to be applied.

Example:

WITH 
    MEMBER [Measures].[Name Length] AS
        Len([Product].[Product].CurrentMember.Name)
SELECT 
    {[Measures].[Unit Price]} ON COLUMNS,
    [Product].[Product].[Product].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]