Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

FDI Report Download with prompts/filter values in the header

Needs Votes
77
Views
6
Comments
Abhishek J
Abhishek J Rank 2 - Community Beginner
edited Jan 8, 2025 10:57PM in Oracle Analytics Cloud and Server Idea Lab

Looking for a way to download FDI/FAW reports in data/excel form along with prompts/filters/parameter values in the header so as to have better information on the report output if viewed later or shared with others.

Not sure if this feature is available today, if yes, please advise.

Regards,

Abhishek

Tagged:
11
Up
11 votes

Needs Votes · Last Updated

Comments

  • Alekya-Kilaru-Oracle
    Alekya-Kilaru-Oracle Rank 3 - Community Apprentice

    If the prompts are applied to the specific report and it got exported as a data/excel file then header filters are auto applied to the report and carried through with the option of Auto-apply filters (default). We can use Sort & Filter option in excel to easily filter the data.

    image.png

    But, if prompts are within the report and canvas is set to auto-fit/free-form, there is no option to export the file in data/excel format.

  • Abhishek J
    Abhishek J Rank 2 - Community Beginner

    What I mean to day that if I download a report with certain filters, is there any option to save/print the filters too along with report output (just like we used to get in OBIEE) so that in future if I see the excel, I know what filters were applied to that report. Hope that explains.

  • Andrew at MKL
    Andrew at MKL Rank 6 - Analytics Lead

    Yes, if I am following @Abhishek J here I am imagining it would be similar to how dimensional filters can be shown in header or footer of FR Studio reports via the "GetCell" or "GetHeading" functions.

  • Oracle Analytics Wizard-Oracle
    Oracle Analytics Wizard-Oracle Rank 5 - Community Champion

    In Self-Service Analytics (a.k.a. Data Visualization, DV) of OAC, I don't think there is a current way to export the filters that are selected and view them via CSV/Excel.

    In Classic Home of OAC, which is pretty much OBIEE, one can create a report with a filter view and then export as formatted to excel:

    image.png
  • Krishna Prasad Kotti-Oracle
    Krishna Prasad Kotti-Oracle Mod

    I am moving this to Oracle Analytics Idea Labs since this more related to OAC platform.

  • User_F5B24
    User_F5B24 Rank 2 - Community Beginner

    We need this enhancement to migrate classic view reports to Modern View