How to filter the following MDX results?

i using following mdx query build dynamic performancepoint dashboard filter.

each user(identified ntid) assigned view type. 

a view type of 1 sees leave
view type of 2 sees first sibling
view type of 3 has no restriction , see dependants

my questions how filter following mdx filter?
[ccr security].[home cc].currentmember.properties( "login" )="xxxx\t827638"

with 

member [measures].[ccr amt] [measures].[cca amt]
member [measures].[login]   [ccr security].[home cc].currentmember.properties( "login" )
member [measures].[view type] ([ccr security].[home cc].currentmember.properties( "view type" ))

select {[measures].[ccr amt], [measures].[login], [measures].[view type]} on columns,
{case
when [measures].[view type]=1 descendants([cca hierarchy].[cca parent node key].&[171779],,leaves)
when [measures].[view type]=2 descendants([cca hierarchy].[cca parent node key].&[171779].firstsibling)
else [cca hierarchy].[cca parent node key].&[171779].children
end} on rows
from [fdm hr summary]

thanks in advance help.

hi, looks trying implement dymanic security using performancepoint dashboard filter. correct way implement on  ssas database level, please take on these articles:

http://msdn.microsoft.com/en-us/library/hh479759.aspx

http://hccmsbi.blogspot.com/2006/08/dynamic-dimension-security-in-analysis.html

this might take time implement work on levels client tools used users.

as quick solution can use clause:

with
member [measures].[ccr amt] [measures].[cca amt]
member [measures].[login] as   [ccr security].[home cc].currentmember.properties( "login" )
member [measures].[view type] ([ccr security].[home cc].currentmember.properties( "view type" ))

select {[measures].[ccr amt], [measures].[login], [measures].[view type]} on columns,

{case
when [measures].[view type]=1 descendants([cca hierarchy].[cca parent node key].&[171779],,leaves)
when [measures].[view type]=2 descendants([cca hierarchy].[cca parent node key].&[171779].firstsibling)
else [cca hierarchy].[cca parent node key].&[171779].children
end} on rows
[fdm hr summary]
where strtoset(“[ccr security].[login].[”+ “xxxx\t827638"+”]”)

best regards, vlad.

SQL Server  >  SQL Server Analysis Services