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

    Full-Time equivalent is not working within USING clause of a FILTER operator in OTBI

    edited Aug 8, 2023 1:17PM in Reporting and Analytics for HCM 1 comment

    I have created an OTBI report using Subject area - Workforce Management - Employee Assignment real time and Full-Time equivalent i am fetching from the "Worker Assignment"."Full-Time Equivalent". I have tried logic based upon Full- time equivalent is null. (FILTER ("Worker Assignment"."Head Count" USING   ("Worker Assignment"."Full-Time Equivalent" IS NULL ) ) ).

    But it is not working. So, i have refer the Doc -(Oracle Taleo Enterprise Edition: Error: "Aggregate is not allowed within USING clause of a FILTER operator." (Doc ID 2175137.1).

    My Query is there is an alternative expression or attribute field for the Full-Time equivalent(FTE) Measure.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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