OBIEE offer several variables which can be set :
This kind of variable can be initiate with the help of SQL statement and can be use in the logical sql
This kind of variable are used to pass value between dashboard prompt and to set some filter.