Hi There, We have an enhancement ask. Existing Analysis report displays prompts, upon selection shows data that satisfies the selected data. Ask is to display parameter values in between header and report data. Can someone help guide me? Thanks in advance, Ruchi

Hi @Ruchi Shivhare , As an alternative, you can setup a presentation variable for each prompt, and then replace the Filters view with a Static Text one. This allows you to display only selected values in prompts.

If you look for a IF ELSE logic, there isn’t one. Presentation variables can display a default value if the variable isn’t set: @{variableName}{ } @{PV_Department}{‘No department selected’} Write a default value that says it isn’t set. Because the static text field isn’t setting variables but just displaying their values, these defaults will not interfere with the analysis. The official documentation covers all these topics. There just is a lot in there and can be challenging to find what you really look for if you don’t have the right keyword to search for.

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 November 2025 Update Unlock faster trends, personalized analytics, and efficient data management with the latest OAC AI and admin enhancements.
Introducing the Oracle Analytics & AI Challenge 2026 Showcase your Analytics & AI skills in this Community Challenge!

Oracle Analytics

Display Prompt Values in the Analysis Report

Accepted answer

421

Views

Comments

Answers

Kathy-Oracle Rank 3 - Community Apprentice

Dec 14, 2023 9:55PM

You're welcome!

0

Oracle Analytics

Categories

Display Prompt Values in the Analysis Report

Answers