Manipulating Session Variables from Answers

As my knowledge, session variables can be manipulated in Answers or dashboard of Presentation services in two possible ways.

• Request Variable
• NQSSetSessionValue 

 Request Variable

A request variable is a variable that is used to temporarily override the value of a session variable. The request variables are defined in the Presentation Services using either :

• Dashboard prompts or
• SET VARIABLE statement.

A variable whose name should not match that of a repository variable or a security system session variable(USER, GROUP etc..).

Using request variables we can change the value of session variables for any request or for all requests in any dashboard. But we can not change the value permanently through out the session. If we want to change the value of session variable for the entire session, then we can use the ODBC function NQSSetSessionValue. To know how to use request variable in presentation services, Click Here >>.

NQSSetSessionValue 

NQSSetSessionValue is an ODBC function, can be used to change the value of session variable for the whole session.

The syntax for this function is : 

                                               call NQSSetSessionValue('DataType VariableName=Value;')

We can call this function from from Issue SQL Directly section of Presentaion Services. To know how to use request variable in presentation services, Cick Here >>.