This proposal introduces a capability to enable session parameter and variable filtering during dataset creation in Oracle Analytics Cloud (OAC) and Fusion Data Intelligence (FDI). This enhancement would allow developers and analysts to create dynamic, context-aware datasets that automatically filter based on session variables established in Data Visualization or Classic Analysis.
Enable dataset creation with built-in session parameter filtering that allows datasets to dynamically filter data based on:
- Session Variables: Variables set within Data Visualization workbooks or Classic Analysis
- User Context Parameters: Security context, organizational hierarchy, or role-based parameters
- Dynamic Filters: Time-based, user-preference, or dashboard-driven filter parameters
A critical limitation exists when comparing data from different time periods or contexts within joined datasets.