Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Support BI Server Session Variables in OAS/OAC Data Visualizer (DV)
Oracle Analytics Data Visualizer (DV) does not currently support BI Server session variables (e.g., NQ_SESSION.*) that are defined and evaluated in the RPD semantic layer.
This creates a functional gap between:
- BI Answers, which fully supports session variables and enterprise semantic logic, and
- DV, which relies only on workbook-level parameters and dataset-level calculations.
As a result, key enterprise use cases cannot be implemented consistently in DV and our users must rely on workbook-level parameters and duplicated calculations, which do not scale and introduce inconsistency. Enabling read-only support for BI Server session, repository, and presentation variables in DV would significantly improve governance, consistency, and enterprise adoption of DV—especially for financial and global reporting use cases.
Best Answer
-
Thanks for your response @Gianni Ceresa . Actually, what I was looking for is the 'Bind parameters to request variables' feature that got added to DV in OAS 2025 and was not available in OAS 2024 DV. We missed this feature earlier. We tested this feature and it works great in OAS 2025 DV.
The new parameter-to-request-variable binding feature in OAS 2025 now enables us to:
- Create a parameter in your DV workbook and the bind that parameter to a request variable. We can then have that request variable override or interact with our RPD session variable (in our case PREFERRED_CURRENCY)
Bind a Request Variable to a Parameter in Oracle Analytics
Attaching the doc from Oracle above if others missed this feature too
0
Answers
-
Hi,
Did you see ?
Or also .
You can reference session variables in DV and get their values to be used in various calculations, formulas etc.
3 -
Great!, Glad you found the feature useful. There will be more enhancements in this area in the next OAS release. The features are already included in OAC.
0
