Hi everybody,
i have a table per user with a field called level,
the request is as follows:
don't show level for specific employees for Users,
for example,
i have this KeyTable:
| UserID | Level |
| 1000 | A |
| 1001 | B |
| 1002 | B |
| 1003 | C |
| 1004 | A |
| 1005 | B |
| 1006 | C |
For user 1 show all level values,
for user 2 the level field should be reduced like that:
| UserID | Level |
| 1000 | |
| 1001 | B |
| 1002 | B |
| 1003 | C |
| 1004 | A |
| 1005 | |
| 1006 | C |
for user 3 the level field should be reduced like that:
| UserID | Level |
| 1000 | A |
| 1001 | |
| 1002 | B |
| 1003 | |
| 1004 | A |
| 1005 | B |
| 1006 | C |
is there a way to do that using section access or any other way?
i cant use a calculated dimension because of security issues( the user can duplicate the table and change the calculated dimension).
please see the attachments of the qvf and excel files,
in the excel there is a Groups table
i thought maybe to create a field for every group of permissions (I have about 100 groups of permissions) so i can create a 100 different fields for the field "Level", but i don't want to loop 100 time over the KeyTable (the table contains 20 Million rows),
i started writing some code in the qvf,
maybe i'm way off here with this solution,
thanks in advance,
Ido.
