ADDCALCULATEDMEMBERS
Description:
This function is used to return a set that is generated by adding calculated members to a specified set.
Syntax:
AddCalculatedMembers(Set_Expression)
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example
"SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
AddCalculatedMembers([Product].[Product Categories].[Category].Members) ON ROWS
FROM [AdventureWorksMF_ValueBased]"