Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE Prompt Limit value through SQL script

Received Response
1
Views
1
Comments
e0be0f4f-9ed0-4d29-ae31-66ebc6741046
e0be0f4f-9ed0-4d29-ae31-66ebc6741046 Rank 1 - Community Starter
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

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

Answers