Table of Contents
OBIEE - Request variable
About
Request Variables are used to update non-system 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 :
- either System
- or Non System
Articles Related
What is the scope of a request variable in Presentation Service ?
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;')
Example
To set a session non system repository variable
System Repository Variable
To set the log level for further analyse
This variable allow you to set the LOGLEVEL for further analyse.
SET VARIABLE LOGLEVEL=4;SELECT "Customer"."Name" FROM SH ...
To disable the query cache hit
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 ...
