IBM Support

Using multi-valued LDAP attributes as session Parameters results in: QE-DEF-0260 Parsing error

Technote (troubleshooting)


Problem(Abstract)

The Proven Practice document "Leveraging multi-valued LDAP attributes as session Parameters" describes the steps necessary to leverage so called multi-valued LDAP attributes as session parameters in Cognos8. The test of the calculation fails when using memberOf as Session Parameter. The test works fine when using the department number.

Symptom

English:

QE-DEF-0260 Parsing error before or near position: 102 of: <distinguishedName>

German:

QE-DEF-0260 Fehler in der Syntaxanalyse vor oder nahe der Stelle: 102 von: <distinguishedName>


Cause

The expression is not correct: #csv(@account.parameters.memberOf)#


Environment

  • IBM Cognos 8 BI MR2 or above
  • LDAP or ADS Namespace with the additional Session Parameter memberOf

Diagnosing the problem

The file <C8_ROOT>/configuration/CQEconfig.xml has been modified

Resolving the problem

Since the result of the attribute memberOf is a string you need to use the single quote function (sq) to surround the result of a string expression with single quotation marks.

The correct expression is: #sq(csv(@account.parameters.memberOf))#

Related information

How to add additional Session Parameters to the availab
Leveraging multi-valued LDAP attributes as session Para


Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Framework Manager
Business Analytics Cognos 8 Business Intelligence Security
Business Analytics Cognos Business Intelligence Cognos Connection Windows 8.3, 8.4, 8.4.1

Historical Number

1028031

Document information

More support for: Cognos Business Intelligence
Security

Software version: 8.3, 8.4, 8.4.1, 10.1, 10.1.1, 10.2, 10.2.1

Operating system(s): Windows

Reference #: 1372300

Modified date: 10 August 2010


Translate this page: