Display Prompt Values in the Analysis Report

Ruchi Shivhare

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

Federico Venturin

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.

Gianni Ceresa

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}{<default>}

@{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.

Gianni Ceresa

You can add the filters view in your analysis between the title and the table.

Ruchi Shivhare

Thank you, Gianni.

Following are our report filters -

And below prompts -

adding filter view adds the first picture vs want to dispay the 2nd one with values selected by the user.

Let me know if there are questions.

Thanks again,

Ruchi

Gianni Ceresa

What version are you using?

In my screenshot it was just a simple example of an analysis without any filter but with some inline prompts. The filters view automatically show the values selected in the inline prompts.

Did you look at the preview of your analysis? Because while you are editing, the inline prompts do not exist (no values set).

Ruchi Shivhare

That explains, yes i was just previewing it.

Added a filter view and below is the result -

it shows the filters and prompts if value is chosen. Any way to not show filters?

Gianni Ceresa

Any way to not show filters?

Not really, because they are indeed filters (there aren't different kind of filters: they are just all filters...).

The default Filter view shows all the filters for the analysis, it's an easy, simple, automated way to have a view of the filters.

Anything else is a DIY solution: you have to build it somehow...

You can use presentation variables as posted above, just remember that you are setting them because they will exist and could impact other things if you aren't careful with the name and their usage.

Depending on the logic of your prompts, if they always limit to one value you can directly show that with a narrative returning a single row and picking the value of the columns of your analysis (without any presentation variable). You can also mix things up and do a "half and half".

In the end you either have the out of the box solution with the filter view and take it as it is, or do it yourself with one of the many ways the tools allow you to build that kind of visualization.

Ruchi Shivhare

Hi Federico,

I appreciate your help, as suggested presentation variable worked.

It shows the prompts if selected. I am now checking where to set conditions if the prompt value is not selected.

Let me know if there's an available help document. I could not find anything in the community regarding this.

Thank you,

Ruchi

Kathy-Oracle

Great responses above. For future reference, if there is an enhancement request for a feature that is not yet available, please reference the following doc for steps using my oracle support:

How To Create An Enhancement Request In IdeasLab For Oracle Analytics (Doc ID 2662737.1)

Ruchi Shivhare

Thank you, both and appreciate your help!

Regards,

Ruchi