Modify Variable

Modify a custom variable to update the SQL query that would be executed in the autonomous data warehouse and return a value that you can use in the reports.

  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Semantic Model Extensions under Application Administration.
  3. On the Semantic Model Extensions page, click User Extensions.
  4. On the Semantic Model Extensions page, under Customizations Sandbox, hover over an applicable sandbox to view Actions, and then click View Sandbox.
  5. On the selected sandbox Details page, click Perform Action, and then select Manage Variables.
  6. In Perform Action, select Modify Variable, select the variables that you want to modify, and then click Next.

    Modify Variable option

  7. Follow through the wizard to modify the variable and click Finish.