Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to find employees not in specific two months.

Received Response
65
Views
11
Comments
2»

Answers

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    I am able to solve for change of employees between months. Yet find solution on another conditions.

    Here is the Parameter created and bind to employees UID.

    SELECT

    XSA('xxx@abc.com'.'Capacity Reports')."Columns"."Emp UID" s_1
    FROM XSA('xxx@abc.com'.'Capacity Reports')
    WHERE
    (("Columns"."Emp UID" IN
    (
    SELECT saw_0 FROM (SELECT
    "Columns"."Emp UID" saw_0
    FROM XSA('xxx@abc.com'.'Capacity Reports')
    WHERE
    "Columns"."Month" = @parameter("Start")(timestamp'')

    ) nqw_1
    )) AND ("Columns"."Emp UID" NOT IN
    (
    SELECT saw_0 FROM (SELECT
    FROM XSA('xxx@abc.com'.'Capacity Reports')
    WHERE
    "Columns"."Month" =@parameter("End")(timestamp'')

    ) nqw_1
    )))