If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Issue with cognos parameter map

Started by kadarla1, 22 May 2012 12:31:02 AM

Previous topic - Next topic

kadarla1

Hi Gurus,

In our cognos Framework Manager model we have created two parameeter maps .

One parametermap is created with manually entering the parameter keys (Key and Value), and another one is created using the option, "Base the parameter map on existing Query Items."

When trying to use these paramter maps in query filter expression as shown below, we get values for static parameter map but not for dynamic one.

#sq($UserRole{'1'})# return user1;user1role
#sq($UserRole1{'1'})# return ''

The query item on which dynamic parameter map is based is taken from a static value function on SQL Server:
select f_bi_get_user_list1( #sq(CAMIDList(','))# ,DEFAULT ) as UserID_Role
above function return 'user1;user1role'

Please let me know if I am doing something wrong, or if there is a better way of doing it.


Thanks in Advance,
kadarla