Oracle Transactional Business Intelligence

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

Conditionally display text in Narrative View on an Analysis

Received Response
11
Views
3
Comments

Hi all,

We're using the Narrative View to display the prompts used in the report (Prompt Name and entered Value) on an Analysis, using the standard approach of "Prompt Name: @{value}{All}" we're displaying "Prompt Name: All" if a prompt isn't populated, however is there a way of conditionally not showing the entire line if the prompt is not entered (to avoid cluttering the output) ?

Screenshot 2025-12-12 102005.png

Thanks in advance.

Carl

Answers

  • Richard Kemp-Eyre
    Richard Kemp-Eyre Rank 5 - Community Champion

    Hello Carl,

    The Filter view will do this automatically for you, though doesn't quite present the details in as simplified form as you are proposing. I use the Filter View in our sickness reports as follows:

    image.png
  • C Hammond
    C Hammond Rank 3 - Community Apprentice

    Thanks for the reply @Richard Kemp-Eyre , I've avoided using the Filters View as the report(s) have several other filters applied that are not presented as Prompts to the users, and the desire is to 'hide' these filters from the recipients of the reports.

    …maybe a case for an ER to create a "Prompts View" that works in the same way as the Filters View.

    Kind Regards

    Carl

  • Richard Kemp-Eyre
    Richard Kemp-Eyre Rank 5 - Community Champion

    Hi Carl,

    Yes, that can be a problem especially if you have plenty of other hidden filters like I have in my screenshot relating to assignment status, etc.

    The alternative would be to tick the 'Contains HTML/Javascript/CSS Markup' and then wrap each line with a HTML or Javascript conditional display element. A quick google suggests it is possible to do this in HTML, but I've never tried it and some things may not work as expected when embedded in an OTBI analytic.