Request Variables are used to update Session Variables in the scope of a logical sql.
You will find it in a OBIEE logical Sql in its SET VARIABLE part.
For instance :
SET VARIABLE MyYear='2000';SELECT Calendar."Calendar Year" saw_0 FROM SH ORDER BY saw_0
Its aim is to set an OBI server session variable :
More: OBIEE - How and where can I set a Request variable (SET VARIABLE) ?
SET VARIABLE MyVariable=MyVale;Logical SQL
For:
By using a dashboard prompt to define the request variable, the scope of the request variable (as a presentation variable) depend then of the dashboard prompt scope (that you can find in the dashboard prompt definition)
Then you can use it exclusively in a dashboard and not for the entire session. For instance, if you leave the dashboard by opening a new report or going into an other dashboard, the value will be reinitialized to the BI server Session Variable.
To modify a repository session variable for the entire session scope, you can fired this odbc function:
call NQSSetSessionValue('Float MyRepositoryVariable=200;')
SET VARIABLE MyYear='2000';SELECT Calendar."Calendar Year" saw_0 FROM SH ORDER BY saw_0
This variable allow you to set the LOGLEVEL for further analyse.
SET VARIABLE LOGLEVEL=4;SELECT "Customer"."Name" FROM SH ...
The variable DISABLE_CACHE_HIT disable the use of the query cache of OBI Server.
SET VARIABLE DISABLE_CACHE_HIT=1;SELECT "Customer"."Name" FROM SH ...