nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Conditionally display text in Narrative View on an Analysis

C Hammond

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) ?

Thanks in advance.

Carl

Find more posts tagged with

Tips & Tricks

Analysis

Report Layouts

Fusion ERP Analytics

Fusion HCM Analytics

Accepted answers

All comments

Richard Kemp-Eyre

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:

C Hammond

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

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.

RVohra

Can you try following and see if it helps, e.g. for Person

@{CASE WHEN '@{Person}{All}' <> 'All'
THEN 'Person: ' || '@{Person}{All}'
ELSE '' END}

Let me know if it works for you.

C Hammond

Thanks for the reply @RVohra - unfortunately using expressions in the narrative gives an expression error though.

RVohra

@C Hammond, it is a one-off requirement so I would advise to log a Service Request for the Oracle Support to see if Product Team can help or suggest if it is currently possible or not. Also, they will suggest if something similar is already in the pipeline or Enhancement Request needed for them. Hope it helps!

C Hammond

Thanks @RVohra - its logged as an ER here (if anyone would like to give it a thumbs up to get it recognised) :

https://community.oracle.com/products/oracleanalytics/discussion/27718/prompts-view-component-for-otbi-analysis

RVohra

Thanks for updating this post and providing the ER link, appreciate it.