howto : Filtering dimension in pivottable

[Oleg Berezhinskiy]

The datasource of my pivot table is olap cube, and i want to show not all
dimension members.
can i to filter dimension on clietn by dimension member property
(like in olap)??

select
Filter( except ( [xxx].Members, Head([xxx].Members,1) ) ,
[xxx].CurrentMember.Properties ("VersionId") =
"6F6D6515-26BB-4D04-B256-60602179DC7F" or [xxx].CurrentMember.Properties
("VersionId") = "964031CD-2BF5-4912-A31E-AE8EB1609E9F") on rows,
Filter( except ( [Aeeieaoee].Members, Head([yyy].Members,1) ) ,
[yyy].CurrentMember.Properties ("BudgetId") =
"04E38C50-B21F-4577-A713-7C92E55D64F8" ) on columns
from Budget