Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OACS Gen2 fires two queries for a report/analysis, one for rendering and one for download
Hi Team,
OACS Gen2 fires two queries for a report/analysis, one for rendering and one for download while On-Prem OBIEE fires only one query for both (rendering and download). This is not acceptable from business users. For ex. in On-Prem OBIEE, if there is an analysis which takes 15 minutes to render the report but while in download it takes fraction of seconds. while in OACS Gen2, it takes 15 mins for render and 15 mins for download. In Total it will take 30 minutes and even during download it fires another query which can also be seen in manage session page.
We need to enhance OACS internal functionality so that it does not fire a query to database while downloading the report/analysis.
Thanks,
Gaurav
Answers
-
This issue is doubling the workload on the databases which the report runs against so needs to be resolved quickly.
1 -
If the report is first opened in Answers, the query runs twice because the FETCH FIRST N ROWS part is different for rendering the report and downloading. This is due to various data limits in OAC. One limit is for rendering, and the other is for downloading.
In classic home page or classic catalog, for an analysis, click on More —> Export —> Data to just export the data without open the analysis.
1 -
Hi @GauravSingh,
Can you please let us know if Pravin's response addresses what your trying to accomplish?0 -
@Pravin Janardanam-Oracle - Could you please share the steps on Home page or catalog page export that how query runs only once.
0 -
@Pravin Janardanam-Oracle - Waiting for response.
0 -
Please find above screenshots for exporting Classic analysis data.
1
