StripCalculatedMembers (MDX)

Retourne un ensemble généré en retirant des éléments calculés d’un ensemble spécifié.

Syntax

  
StripCalculatedMembers(Set_Expression)   

Arguments

Set_Expression
Une expression valide des expressions multidimensionnelles (MDX) qui retourne un ensemble.

Remarks

La fonction StripCalculatedMembers supprime les membres calculés d’un ensemble. Les membres calculés peuvent être ajoutés à un ensemble en utilisant la fonction AddCalculatedMembers , qui retourne les membres calculés définis sur le serveur, ou les membres calculés ajoutés directement dans la requête en utilisant la syntaxe WITH MEMBER.

Example

L’exemple suivant supprime tous les membres calculés de la requête.

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]  
  

Contenu connexe

• Référence de fonction MDX (MDX)