StripCalculatedMembers (MDX)StripCalculatedMembers (MDX)

返回通过从指定的集中删除计算成员而生成的集。Returns a set generated by removing calculated members from a specified set.




返回集的有效多维表达式 (MDX)。A valid Multidimensional Expressions (MDX) expression that returns a set.


StripCalculatedMembers函数从集删除计算成员。The StripCalculatedMembers function removes calculated members from a set. 使用 WITH 成员语法,可以通过使用 AddCalculatedMembers 函数(该函数返回在服务器上定义的计算成员)或在查询本身中添加的计算成员,将计算成员添加到集。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.


以下示例从查询中删除所有计算成员。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)