IBM Support

Setting the Oracle CLIENT_IDENTIFIER on database connection with Cognos Analytics.

Troubleshooting


Problem

How can you set the Oracle CLIENT_IDENTIFIER value on a database connection with Cognos Analytics?

Resolving The Problem

Use the "call" method in the sql tags.

This method is displayed, but not explained at the following location:

[code]https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_asg_example_passing_request_information.html#asg_example_passing_request_information[/code]

Set the Open Connection command block to hold the following example:

<sql>call sys.dbms_session.SET_IDENTIFIER('MY_CLIENT_IDENTIFIER')</sql>

You will be able to see your CLIENT_IDENTIFIER has been set in the v$session table,
as displayed here:

SQL> select client_identifier from v$session where client_identifier is
not null;

CLIENT_IDENTIFIER
----------------------------------------------------------------
MY_CLIENT_IDENTIFIER

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.8;11.0.7;11.0.6;11.0.5;11.0.4;11.0.3;11.0.2;11.0.1;11.0","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22011672

Page Feedback