StripCalculatedMembers(MDX)StripCalculatedMembers (MDX)

이 항목은 다음에 적용됩니다.예SQL Server(2008부터)아니요Azure SQL Database아니요Azure SQL Data Warehouse 아니요병렬 데이터 웨어하우스 THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

지정한 집합에서 계산 멤버를 제거하여 생성된 집합을 반환합니다.Returns a set generated by removing calculated members from a specified set.

구문Syntax


StripCalculatedMembers(Set_Expression)   

인수Arguments

Set_ExpressionSet_Expression
집합을 반환하는 유효한 MDX 식입니다.A valid Multidimensional Expressions (MDX) expression that returns a set.

주의Remarks

StripCalculatedMembers 함수 집합에서 계산된 멤버를 제거 합니다.The StripCalculatedMembers function removes calculated members from a set. 계산 멤버를 사용 하 여 집합에 추가할 수 있습니다는 AddCalculatedMembers 계산된 멤버는 서버에 정의 된 또는 WITH MEMBER 구문을 사용 하 여 쿼리 자체 내에서 추가 된 계산된 멤버를 반환 하는 함수입니다.Calculated members can be added to a set by using the AddCalculatedMembers function, which returns calculated members that are defined on the server, or calculated members that were added within the query itself by using the WITH MEMBER syntax.

예제Example

다음 예에서는 쿼리에서 모든 계산 멤버를 제거합니다.The following example removes all calculated members from the query.

WITH MEMBER Measures.MemberName AS   
   [Date].[Calendar].[July 1, 2003].Properties('Name')  
MEMBER Measures.MemberVal AS   
   [Date].[Calendar].[July 1, 2003].Properties('Member_Value')  
MEMBER Measures.MemberKey AS   
   [Date].[Calendar].[July 1, 2003].Properties('Key')  
MEMBER Measures.MemberID AS   
   [Date].[Calendar].[July 1, 2003].Properties('ID')  
MEMBER Measures.MemberCaption AS   
   [Date].[Calendar].[July 1, 2003].Properties('Caption')  
MEMBER Measures.DayName AS   
   [Date].[Calendar].[July 1, 2003].Properties('Day Name', TYPED)  
MEMBER Measures.DayNameTyped AS   
   [Date].[Calendar].[July 1, 2003].Properties('Day Name')  
MEMBER Measures.DayofWeek AS   
   [Date].[Calendar].[July 1, 2003].Properties('Day of Week')  
MEMBER Measures.DayofMonth AS   
   [Date].[Calendar].[July 1, 2003].Properties('Day of Month')  
MEMBER Measures.DayofYear AS   
   [Date].[Calendar].[July 1, 2003].Properties('Day of Year')  

SELECT StripCalculatedMembers(  
   { Measures.DefaultMember  
   , Measures.MemberName  
   , Measures.MemberVal  
   , Measures.MemberKey  
   , Measures.MemberID  
   , Measures.MemberCaption  
   , Measures.DayName  
   , Measures.DayNameTyped  
   , Measures.DayofWeek  
   , Measures.DayofMonth  
   , Measures.DayofYear  
   }  
   )  ON 0  
FROM [Adventure Works]  

관련 항목:See Also

MDX 함수 참조 ( Mdx)MDX Function Reference (MDX)