Oracle Analytics Cloud and Server

Home› Oracle Analytics› Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Displaying filter selection while exporting the results of a DV Canvas

Accepted answer
122
Views
4
Comments
Sahithi Kolasani-Oracle
Sahithi Kolasani-Oracle ✭✭✭✭
in Oracle Analytics Cloud and Server

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

Tagged:

Best Answer

  • GayathriAnand-Oracle
    GayathriAnand-Oracle mod
    Answer ✓

    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 :

    image.png

    Powerpoint output :

    image.png

    Thanks

    Gayathri

Answers

  • EzequielC-Oracle
    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:

    image.png
    image.png


    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)


    image.png


    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
    Sahithi Kolasani-Oracle ✭✭✭✭

    Thank you @GayathriAnand-Oracle and @EzequielC-Oracle

  • Michal Zima
    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.