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
Why don't you display the export link at the bottom of the analysis? It contains the link for CSV
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
Check this thread, may be it helps. Customize the Export option as ONLY in CSV format
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
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
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.
So that means it is not possible to download the report to CSV with URLS..?
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.
No that means you are using the tool for something totally different than what it's supposed to do
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
