Human Resource VP (secured by HR Position Hierarchy List) AU BI Data Initialization Blocks

E- Business Suite and JD Edwards EnterpriseOne adapters:

A.1.25.9 Human Resource VP (secured by HR Position Hierarchy List) AU BI Data Initialization Blocks

The Human Resource VP HR Position Hierarchy list is determined at user sign-on via one or more Initialization Blocks:

Table A–76 Data Security Role Filters

Name Filter

Dim - HR Position Hierarchy "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Based Position Id" = VALUEOF(NQ_ SESSION.HR_SEC_POS_LIST) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Version" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_VER)) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy ID" = (VALUEOF(NQ_SESSION.HR_SEC_POS_ HIER_ID))

Fact - HR - Time and Labor - Reported Time

"Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Based Position Id" = VALUEOF(NQ_ SESSION.HR_SEC_POS_LIST) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Version" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_VER)) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy ID" = (VALUEOF(NQ_SESSION.HR_SEC_POS_ HIER_ID))

Fact - HR - Time and Labor - Processed Time

Fact - HR - Workforce Balance Information

Fact - HR – Payroll Balance Summary

Table A–77 Initialization Blocks

Variable Name Initialization Block Name

HR_SEC_POS_LIST Not applicable, this is a multi source variable population see below.

HR_SEC_POS_HIER_VER Not applicable, this is a multi source variable population see below.

Data Security Role Filters

The Human Resource VP HR Position 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:

HR_SEC_POS_HIER_ID Not applicable, this is a multi source variable population see below.

HR_SEC_POS_LIST____EBS HR Position Hierarchy ID Version and Position List (EBS).

HR_SEC_POS_LIST____PSFT HR Position Hierarchy ID Version and Position List (PeopleSoft).

HR_SEC_POS_LIST____FUSN HR Position Hierarchy ID Version and Position List (Fusion).

HR_SEC_POS_HIER_VER____EBS HR Position Hierarchy ID Version and Position List (EBS).

HR_SEC_POS_HIER_VER____ PSFT

HR Position Hierarchy ID Version and Position List (PeopleSoft).

HR_SEC_POS_HIER_VER____ FUSN

HR Position Hierarchy ID Version and Position List (Fusion).

HR_SEC_POS_HIER_ID____EBS HR Position Hierarchy ID Version and Position List (EBS).

HR_SEC_POS_HIER_ID____PSFT HR Position Hierarchy ID Version and Position List (PeopleSoft).

HR_SEC_POS_HIER_ID____FUSN HR Position Hierarchy ID Version and Position List (Fusion).

HR_SEC_POS_HIER_LVL_POS_ ID

HR Position Hierarchy Fixed Hier Level.

Table A–78 Data Security Role Filters

Name Filter

Fact - HR - Learning Calendar "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Based Position Id" = VALUEOF(NQ_ SESSION.HR_SEC_POS_LIST) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Version" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_VER)) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy ID" = (VALUEOF(NQ_SESSION.HR_SEC_POS_ HIER_ID))

Table A–77 (Cont.) Initialization Blocks

Fact - HR - Learning Enrollment and Completion

Fact - HR - Learning Enrollment Events

Fact - HR - Absence Event "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Based Position Id" = VALUEOF(NQ_ SESSION.HR_SEC_POS_LIST) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Version" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_VER)) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy ID" = (VALUEOF(NQ_SESSION.HR_SEC_POS_ HIER_ID))

Fact - HR - Recruitment Event Information

Fact - HR - Workforce Event Information

Fact - HR - Workforce Balance Information

Fact - HR - Accrual Transactions - Event Information

Table A–78 (Cont.) Data Security Role Filters

A.1.25.10 Human Resource Analyst (secured by HR Position Hierarchy List) AU BI

In document Oracle Business Intelligence Applications (Page 109-112)