Personalized Information Links are essentially our approach to row level security. Most importantly, they're simple to implement and manage. Check out how to create them.
(16) Answers
0 Comments
+ Add a Comment
Hi All,
Is there a good way to assign a single user to multiple territories. Creating multiple lines for them works but makes the lookup table huge. Is there a syntax that allows me to assign the territories in one cell of the lookup table?
Thanks,
Olga
0 Comments
+ Add a CommentHi All,
I am trying to do a nested set of look up tables and follow this example. In one lookup table, I would like to assign a User Group to a School. In another lookup table, I would like to assign a teacher to a User Group. This way, it avoids having multiple entries for each of my usernames when narrowing the row level security if a teacher belongs to multiple schools.
In the video, what do I use for the expression to replace %=(Current_User)?
Thanks,
Olga
| Attachment | Size |
|---|---|
 LOOKUP_USERGROUP_ENTITY.JPG | 29.96 KB |
| LOOKUP_USERNAME_GROUP.JPG | 29.95 KB |
0 Comments
+ Add a CommentHi Pavan,
Perhaps poorly named - that is User Group in the Spotfire sense of the word, but rather just that the name of the column that joins the two lookup tables. The idea was to have a list of usernames each assigned to a group and a group each assigned to an entity. That way, if a user belonged to multiple entities, I didn't need to take up multiple lines for them in the one lookup table. That would be signified by the group they were assigned to.
I'm experimenting with two joins - one for group to group and the other from entity to entity. I'm just not sure where to put filter to current user statement.
0 Comments
+ Add a CommentUpdate - I was able to filter the two lookup tables by current user, but when I add the same filter statement to the column element of the data table, the analysis won't open.
| Attachment | Size |
|---|---|
| info1.JPG | 105.47 KB |
| info2.JPG | 107.53 KB |
| Capture2.JPG | 46.76 KB |
