StripCalculatedMembers (MDX)

傳回一個藉由移除指定集合中的導出成員的方式所產生的集合。

語法

StripCalculatedMembers(Set_Expression) 

引數

• Set_Expression
  傳回集合的有效多維度運算式 (MDX) 運算式。

備註

StripCalculatedMembers 函數能移除集合的導出成員。使用 AddCalculatedMembers 函數，可以將導出成員新增至集合，該函數會傳回伺服器上定義的導出成員，或是以 WITH MEMBER 語法新增在查詢本身的導出成員。

範例

下列範例會從查詢移除所有導出成員。

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)