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 |
|---|---|
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].[X] AS LEFT("EXAMPLE", 4) SELECT [Measures].[X] ON 0 FROM [AdventureWorksMF]