Hi Experts,
I want to add One more Row Filter for DimClub Table in SSAS role Properties, One Filter is Already in place to Filter the Authentication using LOOKUPVALUE. I want to add one more Filter in this Saying "Please filter these Authenticated people to not see Club name 'XDSS' "
"=DimClub[ActiveDirectoryGroup]=LOOKUPVALUE(Userprofile[DefaultClub],Userprofile[UserName],USERNAME(),Userprofile[DefaultClub],DimClub[ActiveDirectoryGroup])" this Filter is already in place for table DimClub.. I want to add
"='DimClub'[ClubStatus] <> "XDSS" " Can it be Possible to in single statement!!?
I tried with this..
"=DimClub[ActiveDirectoryGroup]=LOOKUPVALUE(Userprofile[DefaultClub],Userprofile[UserName],USERNAME(),Userprofile[DefaultClub],DimClub[ActiveDirectoryGroup]) && DimClub[ClubStatus] <> "XDSS" ".. bad luck in this.. it is not working..
Please help me here . Thanks in Advance.