Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI 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
