Microsoft SQL Server Analysis Services Function Page
Function Name:	StripCalculatedMembers
Category:	Set
Description:	The StripCalculatedMembers function removes all calculated members from a specified set.
Syntax:	STRIPCALCULATEDMEMBERS( «Set» )
Technet Link:	MDX StripCalculatedMembers Function

The query below removes the calculated members ([Measures].[Gross Profit] and [Measures].[Average Unit Price]) from the columns axis.   SELECT       STRIPCALCULATEDMEMBERS({[Measures].[Sales Amount], [Measures].[Gross Profit], [Measures].[Average Unit Price]}) ON COLUMNS       FROM       [Adventure Works]