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

FDI Report Download with prompts/filter values in the header

Abhishek J

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

Find more posts tagged with

Reporting

download

Analysis and Data Visualization

FDI

Needs Votes

Status: Needs Votes

Comments

Alekya-Kilaru-Oracle

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.

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

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

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

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:

Krishna Prasad Kotti-Oracle

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

User_F5B24

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