RIGHT
Description:
The MDX Right() returns a specified number of characters from the right side of a string.
Syntax:
RIGHT(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 RIGHT 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 RIGHT("EXAMPLE", 4) SELECT [Measures].[X] ON 0 FROM [AdventureWorksMF]