Oracle Communities

Oracle Analytics and AI

Child Item

Displaying filter selection while exporting the results of a DV Canvas

Hi Experts,

We have a request from customer that they want to get the filter being applied on the report while we export the output to a ppt file.

I have noticed if we are using a dashboard prompt, it is showing the values selected. Otherwise for a filter, it's not displaying the list of filter values applied.

Is there any way to achieve this?

Also, can we display the date when this report was last run on the reports? it is available in classic OAC.

Thank you,

Sahithi

Find more posts tagged with

Analysis and Data Visualization

Filters

Accepted answers

GayathriAnand-Oracle

In "present" mode, for the active canvas properties, there is a filter bar section where you choose to include the filters applied to the visualization. When you check these filters to true and do an export the filter pane will be included in the export :

Powerpoint output :

Thanks

Gayathri

All comments

GayathriAnand-Oracle

Powerpoint output :

Thanks

Gayathri

EzequielC-Oracle

Hi Sahithi,

If you are using Analytics Classic with Analyses, you could use a Filter View. See how the Year filter is shown in the view and the PPT file:

For showing the date in Analytics Classic, you could set up a repository variable and populate it with the date the same way I am using the USER variable. Then edit the Title View in the analysis to display that variable. Example syntax for the Title view:

This Analysis was run by @{biServer.variables['NQ_SESSION.USER']} user

For showing the date in Data Visualization, you could create a calculation that references that variable and include it in another view in the same canvas with your data. The syntax to reference a repository variables is:

VALUEOF(NQ_SESSION.USER)

Look at the following documentation for more details on using variables:

https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/work-repository-variables.html#GUID-C637CF9F-3C2B-4B21-97E6-814FAC7E8F68

Regards,

Ezequiel.

Sahithi Kolasani-Oracle

Thank you @GayathriAnand-Oracle and @EzequielC-Oracle

Michal Zima

@EzequielC-Oracle If you would read carefully, this discussion is named "Displaying filter selection while exporting the results of a DV Canvas" and your answer deals with good old "Classics"....

@GayathriAnand-Oracle nand-Oracle Your recommendation does not reflect one basic fact - filters conditions, displayed for particular visualization does not display filter conditions passed to visualization either from Filter Bar on canvas or from Dashboard Filter visualization. Which I think is what it should be the goal. So your "solution" is not working, unfortunately....

In DV, there is similar feature missing, like in Classics (described by @EzequielC-Oracle ) - where you add Filtre view into analysis, which is displaying all filtering conditions applied to analysis - including those "dynamic" passed from dashboard prompts.

So @Sahithi Kolasani-Oracle , I would encourage you to create Idea for this in Idea Lab.

User_WQKHO

@GayathriAnand-Oracle @EzequielC-Oracle @Michal Zima what about the opposite? I want users to be able to select prompt values, but don't want to show the filters applied in ppt extracts. Cannot find this option in OAS2024 although we had the option in prior versions