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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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 Analytics Cloud and Server

Display Prompt Values in the Analysis Report

Accepted answer

344

Views

Comments

Answers

Kathy-Oracle Rank 3 - Community Apprentice

Dec 14, 2023 9:55PM

You're welcome!

0

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Display Prompt Values in the Analysis Report

Answers