Support BI Server Session Variables in OAS/OAC Data Visualizer (DV)

Dhaval Parikh Stantec

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.

Gianni Ceresa

Hi,

Did you see https://support.oracle.com/support/?kmContentId=2436328&page=sptemplate&sptemplate=km-article ?

Or also https://oracledataviz.blogspot.com/2020/05/using-of-session-and-repository.html .

You can reference session variables in DV and get their values to be used in various calculations, formulas etc.