StripCalculatedMembers (MDX)StripCalculatedMembers (MDX)

SI APPLICA A:sìSQL Server Analysis ServicesnoAzure Analysis ServicesAPPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Restituisce un set generato dalla rimozione dei membri calcolati dal set specificato.Returns a set generated by removing calculated members from a specified set.

SintassiSyntax


StripCalculatedMembers(Set_Expression)   

ArgomentiArguments

Set_ExpressionSet_Expression
Espressione MDX (Multidimensional Expression) valida che restituisce un set.A valid Multidimensional Expressions (MDX) expression that returns a set.

OsservazioniRemarks

Il StripCalculatedMembers funzione rimuove i membri calcolati da un set.The StripCalculatedMembers function removes calculated members from a set. I membri calcolati possono essere aggiunti a un set tramite la AddCalculatedMembers funzione, che restituisce i membri calcolati definiti nel server o i membri calcolati che sono stati aggiunti all'interno della query stessa tramite la sintassi 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.

EsempioExample

Nell'esempio seguente vengono rimossi tutti i membri calcolati dalla query.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]  

Vedere ancheSee Also

Riferimento alla funzione MDX ( MDX )MDX Function Reference (MDX)