nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Oracle Analytics - Restricting queries generated while using Filters in a Canvas

Hasan Sd

Hii….As shown in below image, in my canvas ,I observed while using the Mobile No. Filter that as i type the digits, queries are generated in the background for each digit typed .This reduces the speed of Mobile No. searches for Very Large Data . Can we restrict this and make sure that the search happens only when Complete Mobile no. is typed on click of Add button or any other way ? Pls advice us regarding this as it is our customers requirement .

Find more posts tagged with

Accepted answers

Mostafa Morsy-Oracle

@User_Y6C7L

you can disable Auto-Apply For Filters please check

All comments

Sumanth V -Oracle

@User_Y6C7L - There is no option to do so currently in Oracle Analytics DV. Please try using Dashboard filters instead and that gives you a better performance than this. Kindly review the below document for more details on the feature.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/use-dashboard-filters.html#GUID-2C64BB31-6651-474A-9C66-35668F9B9FA6

Hasan Sd

Thanks @Sumanth V -Oracle for the reply . Also customers sometimes complain that after copy pasting a Mobile No. in the filter they do not get the records , they have to refresh the page and then do it again to get the records . Is this something you are aware of ? If yes, then pls suggest some solutions.

Sumanth V -Oracle

@User_Y6C7L - I haven't encountered this scenario before, but it seems possible that the session may have transitioned to an inactive state after being left unattended for an extended period. If the issue can be consistently reproduced, please feel free to create an SR with detailed steps, and we'll be happy to investigate further. Thanks

Steve F-2

Is the underlying dataset configured for Live or Cached?

Mostafa Morsy-Oracle

@User_Y6C7L

you can disable Auto-Apply For Filters please check

Hasan Sd

@SteveF-Oracle Dataset is configured Live.

@Mostafa Morsy-Oracle Thanks a lot for the info . It's better now .