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

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - 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)

3 - How-to

3.1 - Modification of the instanceconfig.xml

In the instanceconfig.xml file anywhere between the <ServerInstance></ServerInstance> 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
Advertising

3.2 - 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

4 - 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

5 - Reference