Advanced Techniques: Reference Stored Values in Variables

You might want to create an analysis whose title displays the current user's name. You can do this by referencing a variable.

You can reference several different types of variable in your analyses, dashboards, and actions: session, semantic model (repository), presentation, request, and global. Content authors can define presentation, request, and global variables themselves but other types (session and semantic model (repository) are defined for you in the semantic model.

Note: Oracle Analytics doesn’t support the variables :user and :password in data source connection credentials.

Type of Variable Defined in Defined by More Information

Session

  • System

  • Nonsystem

Semantic model

Data model authors

About Session Variables

Semantic Model (Repository)

  • Dynamic

  • Static

Semantic model

Data model authors

About Semantic Model (Repository) Variables

Presentation

Prompts for analyses and dashboards

Content authors

About Presentation Variables

Request

Prompts for analyses and dashboards

Content authors

About Request Variables

Global

Analyses

Administrators

About Global Variables and Create Global Variables