Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reference Session and/or Repo Variables in URL Navigation Data Action?

Accepted answer
32
Views
1
Comments
M.K.Mori
M.K.Mori Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Is there a way to reference Session and/or Repository Variables in URL Navigation Data Actions directly?

Perhaps a syntax akin to @parameter("MyParm") or ${env:ENV_VAR}...?

As a workaround, I am creating parameters with SQL and referencing them in the action instead.

My parameter SQL looks like this: SELECT VALUEOF("REPO_VAR") FROM "Some Random Table" FETCH 1 ROWS ONLY

(Can't use "FROM DUAL" in this context...?)

Appreciate any tips, hints, or suggested refinements!

Tagged:

Best Answer

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod
    Answer ✓

    Hi @M.K.Mori ,

    I don't think repository/session variables can be referenced directly in DV data actions.

    Your workaround seems to be the only way to achieve your goal atm. "FROM DUAL" can't be used in logical SQL expressions, but you can reference any dataset or subject area names used in the workbook.

    I tried to use workbook calculations instead of parameters. While repository/session variable values can be read properly using the VALUEOF(...) function, calculations cannot be used in URL Navigation data actions using the ${valuesForColumn:column} syntax :(