Associated OSUSER

[#1]

Record	User	Team	Active Directory
1	PersonA	Team1	Domain\PersonA
2	PersonB	Team1	Domain\PersonB
3	PresonC	Team2	Domain\PersonC

Hello All,

I have the above data set,

I am using the following set : only({$<[Active Directory]= {'$(=OSUSER())'}>}Record) which is returning only the Records associated with the user logged in.

Can anyone help with the set analysis to return the Records relating to the TEAM of the user that is logged in?

Example:

If I log in as 'Domain\PersonA' I should be able to see Records 1 & 2 as they are within my team,

Any help would be much appreciated.

Thanks

Jeremy

[#2 · Accepted solution]

Hi Jeremy,

You can achieve this by using the P() function like this:

For example if you want to display in a text box the related records to the team:

=Concat({$<Team = P({<[Active Directory]= {'$(=OSUSER())'}>} Team)>} Record, ',')

Or if you are using it as a dimension to display for example the related users, the calculated dimension would be like this:

=Aggr(Only({$<Team = P({<[Active Directory]= {'$(=OSUSER())'}>} Team)>} Record), Record)

So it may need a bit of manipulation depending on how you'll be using it.

Hope this will help you in your case.