Tuesday, March 3, 2009

OBIEE NQSSetSessionValue

image

When playing around with session variables in the repository in the help context you wil find a reverence to NQSSetSessionValue:

image

But if your looking for how to use it........ (At least I couldn't find anything on the net or in the docs.). Anyhow: after logging an SR I was pointed in a direction to find a solution. The way to use this function is to issue an direct SQL request from a web page by ussing the ?IssueRawSQL?SQL (FI: http://vmobiee:9704/analytics/saw.dll?IssueRawSQL?SQL )

image

(you have be granted the right permission for this!)

image

Next you have to format the request like:

call NQSSetSessionValue('DataType VariableName=Value;')

FI: call NQSSetSessionValue('Float MYSESSIONVAR=11;')call NQSSetSessionValue('String MYSESSIONVAR=Test;')

The types allowed are: Integer, String, Float, Date, Time and DateTime.

image

Till Next Time

2 comments:

ebola said...

Hi john
thanks so much..
I tried to change session variables from reports and prompts with NQSSetSessionValue . Bu i can't. Did you try

John Minkjan said...

@Ebola,

As far as I know you can't.

regards

John