Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE GO URL to download Report in CSV
hi, Our business users wants an obiee URL which automatically opens the report with report prompts and downloads the same report into CSV format. Is there any way to do this? Our OBIEE Version is --OBIEE 12c Version-12.2.1.0.160419 Thanks Ram
Answers
-
Why don't you display the export link at the bottom of the analysis? It contains the link for CSV
0 -
Gianni, We have the export link but instead of login to BI select the report parameters and download it into CSV.Our users wants the direct URL which dowbloads the reports into CSV. Reason is:we have 340 reports which has to be exported to CSV every day Each report size is 15 to 20 MB. Thanks Ram
0 -
Check this thread, may be it helps. Customize the Export option as ONLY in CSV format
0 -
George, that link doesn't work for me. the below is our report URL.When the BI user enter the URL on their browsers it should automatically downloads the report. https://salesforcebi.com/analytics/saw.dll?PortalGo&Action=prompt&path=%2Fusers%2F76694598046%2FRcp_attendance_weekly_test&Format=txt&Extension=.csv
0 -
7688438 wrote:Gianni, We have the export link but instead of login to BI select the report parameters and download it into CSV.Our users wants the direct URL which dowbloads the reports into CSV. Reason is:we have 340 reports which has to be exported to CSV every day Each report size is 15 to 20 MB. Thanks Ram
^--- That in itself already shows that you have a far more basic problem with your fundamental approach to analytics. OBI isn't a data pumping and dumping tool
0 -
7688438 wrote:Gianni, We have the export link but instead of login to BI select the report parameters and download it into CSV.Our users wants the direct URL which dowbloads the reports into CSV. Reason is:we have 340 reports which has to be exported to CSV every day Each report size is 15 to 20 MB. Thanks Ram
Don't you have the feeling you are using the wrong tool for the wrong job?
A CSV of 15-20Mb smells data pump style of job.
340 exports daily?
That's not BI and even less OBIEE.
Look at Publisher, it will already be a better match for the need.
0 -
So that means it is not possible to download the report to CSV with URLS..?
0 -
To have a link you use from outside OBIEE you have to manage the authentication first. OBIEE will do something only with a valid session. The actual link to export in CSV does a POST call to a page with lot of parameters (including the session) and the result is the CSV file to download.
Just an example:
As you can see there is a lot which is sent to the page to get the CSV back, you will not manage to get that in a LINK you save somewhere outside OBIEE.
0 -
No that means you are using the tool for something totally different than what it's supposed to do
0 -
Chris, thanks for your update.I'm looking for different options to find out the soluton. We have 5 different reports and each report has 300 different prompt values.Instead of logging to each report and selecting each prompt value,our business asked us to provide obiee URL's which automatically downloads the reports into CSV. thanks Ram
0
