Manage Variables

Administrators use Manage variables in Space Management to create and maintain variables for reports, dashboards, security filters, and Birst Connect queries.

  • Types of Variables
    • Repository Variables: These variables are refreshed when data is processed. Birst provides built-in repository variables related to data loading, such as LoadDate, LoadStartTime, LoadDateSFDC, LoadCompletionTime, and LoadNumber.
    • Session Variables: These variables are refreshed with each new user session. Birst provides two built-in session variables, USER and UserLocale. USER can help drive data level security for a space by dictating what data a specific user is able to see. UserLocale is determined by the Language option on the Birst User Settings page. These are not valid for ETL scripts.

  • Creating Variables

    Define variables as Query or Constant based, select Return Value, single or multiple, and specify Default Value.

  • Using Cases
    • Dynamic filters in reports and dashboards
    • Data-level security
    • Birst Connect and application connector queries
Note: 

Use descriptive names for easy identification.

Validate BQL expressions before saving.

Publish parent space for variable changes to reflect in child spaces.

Related topics