You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Query Regarding Adding a Secured List Table to Oracle BI Data Model

    in Reporting and Analytics for HCM 2 comments

    Summary:

    Query Regarding Adding a Secured List Table to Oracle BI Data Model

    Content (please ensure you mask any confidential information):

    Hello,

    I am working on a BI data model based on a converted OTBI report and need to incorporate a secured list table to restrict data access. The current data model includes the following SQL query:

    SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
    0 s_0,
    "Workforce Management - Worker Assignment Real Time"."Business Unit"."Business Unit Name" BusinessUnit,
    "Workforce Management - Worker Assignment Real Time"."Department"."Department Name" DepartmentName,
    "Workforce Management - Worker Assignment Real Time"."Department"."Supervisor Full Name" ManagerName,

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!