2 Replies Latest reply on Jun 1, 2016 6:18 AM by Saro

    Minus operation not working in obiee 11g prompt

    Saro

      Hi friends,

       

      Im in obiee 11.1.1.7.150120. And in the prompt based upon the sql results im issuing the below query

       

      SELECT "Fact1-payroll"."Employee Number" FROM "8 - HR-Payroll"

      where "Fact1-payroll"."Period" = '@{v_from_period}{OCT-15}'

      MINUS

      SELECT "Fact1-payroll"."Employee Number" FROM "8 - HR-Payroll"

      where "Fact1-payroll"."To Period" = '@{v_to_period}{NOV-15}'

       

      But the prompt values are not showing up. Suppose in place of MINUS if i use UNION/UNION ALL/INTERSECT then the prompt values are appearing, but im not sure about the minus operation like why it is not working.

       

      Kindly help with a fix for this problem.

       

      Thanks in advance.

       

      Regards,

      Saro