StripCalculatedMembers (MDX)
Mengembalikan set yang dihasilkan dengan menghapus anggota terhitung dari set tertentu.
Sintaks
StripCalculatedMembers(Set_Expression)
Argumen
Set_Expression
Ekspresi Ekspresi Multidminsional (MDX) yang valid yang mengembalikan satu set.
Keterangan
Fungsi StripCalculatedMembers menghapus anggota terhitung dari satu set. Anggota terhitung dapat ditambahkan ke set dengan menggunakan fungsi AddCalculatedMembers , yang mengembalikan anggota terhitung yang ditentukan di server, atau anggota terhitung yang ditambahkan dalam kueri itu sendiri dengan menggunakan sintaks WITH MEMBER.
Contoh
Contoh berikut menghapus semua anggota terhitung dari kueri.
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]