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