Learning Manager (Secured by HR Supervisor Hierarchy List) BI Data
The Learning Manager HR Supervisor Hierarchy list is determined at user sign-on via one or more initialization blocks.
Variable Name | Initialization Block Name |
---|---|
HR_SEC_PERSON_ID |
Not applicable, this is a multi source variable population see below. |
HR_SEC_PERSON_ID____EBS |
HR Security Person ID List (EBS) |
HR_SEC_PERSON_ID____PSFT |
HR Security Person ID List (PeopleSoft) |
HR_SEC_PERSON_ID____FUSN |
HR Security Person ID List (Fusion) |
HR_SEC_PERSON_ID____FBI_SDS |
HR Security Person ID List (FBI SDS) |
Data Security Role Filters
The Learning Manager HR Supervisor Hierarchy list Security is applied depending on the roles the user is granted, and when it is applied it is supported by the following HR logical facts and dimensions:
Name | Filter |
---|---|
Dim - HR Supervisor Hierarchy |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |
Fact - HR - Learning Calendar |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |
Fact - HR - Learning Enrollment and Completion |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |
Fact - HR - Learning Enrollment Events |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |