Troubleshooting
Problem
This document explains why it is not possible to use a value from a data source as the input into a parameter map function, i.e., why you can't enter a query item inside the {} of a parameter map macro expression like $ParameterMapName{}#, and provides a workaround solution.
Cause
Parameter maps are used to substitute entries in the SQL that Cognos BI sends to the database, therefore any items that are to be substituted by the parameter map need to come in before any queries are sent to any data sources. Parameter maps will accept session parameters as inputs because sessions parameters are read from the authentication provider before any reporting data source has been queried.
Resolving The Problem
If storing the parameter information in an authentication provider like an LDAP is not possible, then the solution for such a requirement is to create a lookup table in the database which holds the key and value data in two columns.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21339145