LEN
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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 |
|---|---|
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]