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

    Filter Logical SQL based on dashboard prompt with multiple values

    edited Dec 5, 2019 1:37PM in Reporting and Analytics for HCM 13 comments

    Content

    Hi

    Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down through the data based on their 4 tier HR Org Hierarchy, which is structured thus Directorate > Service Area > Department > Team. Positions and assignments are at team level.

    As part of this I've developed a Position Vacancy analysis, which is based on Logical SQL as I need to outer join between the Position Real Time and Worker Assignment Real Time subject areas.

    The problem I'm having is filtering the Logical SQL (via WHERE clause) using a a dashboard prompt with multiple specific values (not just all). For instance the Business Unit dashboard prompt sets the presentation variable LNMGR_BU, which I can reference in the Logical SQL thus:

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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