Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

Calculated Field in OTBI Prompt

Question

Views

Comments

Pradnya_Pampatwar Rank 2 - Community Beginner

Nov 22, 2023 12:17PM in Oracle Transactional Business Intelligence

Summary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below:

Can anyone guide on how to have Prompts for no. 2 and 3 .

How to use "Grade Code" in Prompts and have the proper result?

Content (please ensure you mask any confidential information):

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

Code Snippet (add any code snippets that support your topic, if applicable):

CASE WHEN MAX("Grade"."Grade Code") = MIN("Grade"."Grade Code") THEN 'N' ELSE 'Y' END "Change of Grade"

Tagged: