I want to restrict the values for prompt in OTBI reports.

Summary:

I had applied a prompt for customer contract name in OTBI report, it is fetching all the values present in that column but I need to fetch only those values that are related to contracts only.

Subject Area: Used Project Billing - Revenue Real Time.

Prompt Column: Contract Customer Details"."Contract Customer Name

Need to restrict for this column: Project Contract Header Details"."Contract Name

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic,

if applicable):