OAS 2024 - The visuals built off of the dataset in DV not respecting the expression filter

Question

We are currently using OAS 2024 and encountering an issue where a table in Data Visualizer does not respect the Expression filter when the source is a dataset built off the subject areas. However, the Expression filter works as expected when using the subject areas directly. We have a list of projects displayed in a table, and the Expression filter is used to restrict the list. The behavior seems unusual, so we wanted to check if anyone else is experiencing this issue or has a plausible explanation for it.

viktyagi-Oracle · Answer

This issue in OAS 2024 Data Visualizer likely occurs because filters behave differently in datasets than in direct subject area queries. When using a dataset, the Expression filter may not push down correctly to the source, potentially due to caching, dataset-level transformations, or security rules. To resolve this, try applying the filter at the dataset definition level, clear cache, and compare the Logical SQL generated in both cases to identify discrepancies. Also, ensure that row-level security is consistently applied.