StripCalculatedMembers (MDX)
Restituisce un set generato dalla rimozione dei membri calcolati dal set specificato.
Sintassi
StripCalculatedMembers(Set_Expression)
Argomenti
- Set_Expression
Espressione MDX (Multidimensional Expression) valida che restituisce un set.
Osservazioni
La funzione StripCalculatedMembers rimuove i membri calcolati da un set. I membri calcolati possono essere aggiunti a un set mediante la funzione AddCalculatedMembers, che restituisce membri calcolati definiti nel server oppure membri calcolati che sono stati aggiunti nella query tramite la sintassi WITH MEMBER.
Esempio
Nell'esempio seguente vengono rimossi tutti i membri calcolati dalla 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]