STRIPCALCULATEDMEMBERS
Description:
This function is used to return a set generated by removing calculated members from a specified set.
Syntax:
StripCalculatedMembers(Set_Expression)
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
WITH MEMBER [Measures].[Base Count] AS
Count(StripCalculatedMembers([Product].[Product Categories].[Category].AllMembers))
MEMBER [Measures].[All Count] AS
Count([Product].[Product Categories].[Category].AllMembers)
SELECT {[Measures].[Base Count], [Measures].[All Count]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]