Showing posts with label NQSSetSessionValue. Show all posts
Showing posts with label NQSSetSessionValue. Show all posts

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