Group global variable

SUGGESTED

There is a @@USER variable.  I'm looking for a similar variable that will report an SEI group.

I have a budget process that I need to control the viewing of payroll data by department.  For example if user A logged into SEI is a member of SEI group 'DEPT35', user A should only see payroll data for department 35, if user B logs in and is part of DEPT50, then user B should only see payroll data for department 50 when using the same process.

Parents
  • 0
    SUGGESTED

    I believe there is no such variable available but you may be able to create your own.

    Under Security>Restrictions you can add a process restriction per group so for group DEPT35 you'll add a restriction similar to this table.column='DEPT35' and then you'll do the same for each department.

    If you are looking for a global variable because you are trying to avoid to create separate restrictions for each department. Then you can technically accomplish this by creating your own global variable that would contain a list of departments that the current user is a member of. However, you'll need some advance knowledge of SEI variables and SQL. You can use the fSQLCSVArray function in the global variable and write some SQL that joins the SEC_USERS, SEC_USER_GROUP and SEC_GROUPS tables and in the where clause filter on ##CurrentUser, this would give you the list of groups. Then you can use this global variable in your process restriction filter.

  • 0 in reply to Israel Braunfeld

    Thanks.  I'll try both suggestions.

Reply Children
No Data