Does OAC support "Lazy loading of visualizations/charts”?
SummaryOAC's ability to fetch data from database based on the filter applied by the user in OAC project
I have a dataset pointing to a table in Autonomous Data Warehouse (ADW DB) and am fetching about 4.5million records from this table. I am fetching all the records from this dataset and am using it in a dataflow to perform some transformations/calculations as part of it. The resultant dataset is being used in a project dashboard in OAC.
Issue: As huge data (4.5 million records) is being fetched from DB, the charts in OAC take longer time to load (4-5min). This is definitely a pain point for any customer, who has to wait so long, for all the charts in a canvas to load up. We do have a top level date filter in the canvas (applicable for all charts ) that would show the data for 'last one week' only and this is by default.