Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAS DV datasets resulting in extremely poor performance.
We noticed in the past number of weeks that any of our DV's in OAS (V7) built off datasets are performing very poorly. When we rebuild the DV direct from a subject area, all looks great. Is there a configuration or setting we need to adjust?
Initially all our DV's (dataset or subject area based) were performing well. This seems to be either an issue that has resulted over time OR a setting changed that we're not aware of.
Are we the only customers with this issue?!
Joanne
Answers
-
Hi @Joanne Mc ,
Could you please share more details about the datasets which are not performing as expected? Are they based on a database connection? Are you mixing different sources (e.g. database, files, subject areas)? How many tables do they contain? Are BI Server and XSA cache enabled?
I'd highly recommend to enable usage tracking and use the data it collects to compare the physical queries generated by workbooks on datasets which are performing poorly with others based on subject areas.
0 -
Federico, thank you. It's a very simple setup.
The subject area solution is using a dbase connection. We're not mixing any sources. One of the datasets performing poorly is based on a very small excel sheet of less than 70 rows.
Yes cache is enabled.
0 -
@Joanne McCann Did you get any resolution?
0 -
@User_6C5G3
Arita, closing very old thread, please open a new thread with all the appropriate details.
Also, as an Oracle employee, you are required to update your Display Name in your profile identifying yourself as Oracle.
You can also use internal channels, if you desire.0
