1 Reply Latest reply on Feb 6, 2018 6:45 PM by Christian Berg

    OBIEE Prompt Limit value through SQL script

    e0be0f4f-9ed0-4d29-ae31-66ebc6741046

      I want to create the script (Within prompt )so that I can limit the values of employee location name as per employee location country. I have created the below mentioned script however the script populate the country name instead of limiting location name as per country.

       

      SELECT Distinct"Employee Location"."Employee
      Location Name" FROM "Human Resources - Workforce Profile" where "Employee
      Location"."Employee Location Country Name " IN (SELECT
      "Employee Location"."Employee Location Country Name" FROM
      "Human Resources - Workforce Profile")
      FETCH FIRST 65001 ROWS
      ONLY