Connect analysis to excel?

Joana Falcao

Summary:

We wanted to connect the results of an analysis directly to an excel.

Content (required):

We wanted to connect the results of an analysis made in Oracle Fusion, on the 'Reports and Analytics' offer directly to an excel. Without have to go run it and then copy the results manually from the exported output to the correct file.

Is there any way to do this? Maybe through an excel add-in of some sort?

If not for this offering, maybe for OTBI?

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications - 22B

Code Snippet (add any code snippets that support your topic, if applicable):

Joana Falcao

If anyone needs, this is possible using smartview.

Raghavendra Raghunath-Oracle

Hi @JoanaFalcao , did you mean, if there is a way to export the data from an OTBI analysis to a spreadsheet without running the analysis?

In the catalog, just below the report, you find the 'more' button . You click on that to find an 'export' option, which on clicked will export the analysis output to the file

Raghu

Joana Falcao

Hello @Raghavendra Raghunath-Oracle , thank you for your reply, but was not exactly what I was asking.

I was thinking in running it through the excel with an add-in, similar to what IBM cognos has (if you know the software).

We have an excel that treats several sources of information to produce a report, but we need to go to the ERP, run the analysis manually and paste it to this excel that already has the logic implemented. With most of our sources of information we can simply "refresh" the data through an excel add-in. I was thinking if there is something similar to that with OTBI analysis.

Regards,

Joana