Create a Session Variable

Follow these steps to create a session variable.

  1. Sign into to Oracle Fusion Data Intelligence.
  2. Navigate to Semantic Model Extensions and click User Extensions.
  3. Click Create Sandbox, enter the sandbox details, and click Done.
    Create Sandbox dialog

  4. Select Manage Variables in the Perform Action dialog.
    Manage Variables option in the Perform Action dialog

  5. Select Create Variable.
    Create Variable option in Perform Action dialog

  6. In step 2 of the wizard, provide name for the initialization block and the query to be used as part of initialization block. If you want the initialization block to be executed after any other, then select the same initialization block in Preceding Block.
    Initialization block details in step 2 of the wizard

  7. Provide the variable name to hold the information returned by the initialization block. Since the initialization block returns list, you must define Row-Wise Initialization Variable.
    Row-wise initialization variable

  8. For the sandbox, click on 3 dots and select Apply Changes.
  9. Validate and Publish the sandbox
  10. Sign into Oracle Analytics Cloud and start using the variable wherever it is needed. In this example, create a calculated measure to indicate if EBS GL module is activated. 
    Create a calculated measure to indicate if the EBS GL module is activated

    Since the module is activated and the system retrieves the variable value from the initialization block, the same is reflected in the Oracle Analytics Cloud visualization.
    Visualization reflecting the variable value retrieved from the initialization block