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
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
