OBIEE 10G - How to set a request/session variable using the Saw Url (Go/Dashboard)

Obi Edition

About

The go url permit you to pass a sql and a filter but what about if you need to pass a request variable in order to set a session variable.

You cannot set the value of any System Security Session variable (specifically USER, PROXY, GROUP and WEBGROUPS) using any source method (e.g.: url, cookie, httpHeader)

How-to

Modification of the instanceconfig.xml

In the instanceconfig.xml file anywhere between the

tags:

<Auth>
<UserIdPassword enabled="true">
<ParamList>
<Param name="NQ_SESSION.TEST_VAR" source="url" nameInSource="SETVAR"/>
</ParamList>
</UserIdPassword>
</Auth>

where :

  • NQ_SESSION.TEST_VAR is the session variable name (be careful case sensitive)
  • SETVAR is the Go Url Parameter

The Go Url Syntax

Youo just have to add the value that you have set in the “nameInSource” tag from the node param as :

http://obiserver:9704/analytics/saw.dll?Dashboard&SETVAR=SomeValue

Support

If you try to set the value of a system security session variable (specifically USER, PROXY, GROUP and WEBGROUPS), you will have in the log :

nQSError: 10018: Access for the requested connection is refused
nQSError: 1315 You do not have the permission to set the value of the variable :USER

Reference





Discover More
Obiee Answers Advanced Sql Clauses
OBIEE - How and where can I set a Request variable (SET VARIABLE) ?

A request variable is an OBI Server Session Variable but with the scope of the request. The value of the session variable will not be change for the session. You can set it up in three main ways : ...



Share this page:
Follow us:
Task Runner