Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAS 2024 - The visuals built off of the dataset in DV not respecting the expression filter

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.
Answers
-
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.
0