StripCalculatedMembers(MDX)

지정한 집합에서 계산 멤버를 제거하여 생성된 집합을 반환합니다.

구문

  
StripCalculatedMembers(Set_Expression)   

인수

Set_Expression
집합을 반환하는 유효한 MDX(다차원 식) 식입니다.

설명

StripCalculatedMembers 함수는 집합에서 계산 멤버를 제거합니다. 계산 멤버는 서버에 정의된 계산 멤버 또는 WITH MEMBER 구문을 사용하여 쿼리 자체 내에 추가된 계산 멤버를 반환하는 AddCalculatedMembers 함수를 사용하여 집합에 추가할 수 있습니다.

예

다음 예제에서는 쿼리에서 계산된 멤버를 모두 제거합니다.

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]  
  

참고 항목

MDX 함수 참조(MDX)