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

Picklist Prompt in Framework

Started by ghostraider, 30 Apr 2008 09:05:10 AM

Previous topic - Next topic

ghostraider

Can someone help me with how to implement picklist in Framework Manager? I have created a new namespace added a calculation item and in the expression i chose 'promptmany'. My user has a list of names that he uses, he wants me to display all the names in the list and he will select any names he wants based on his needs. How can this be accomplished?

Thank You!!

raro

1. Create a QS: PickList_Names with two columns for Shown and Filter
   .. in Where-Clause apply a filter that cuts down the picklist to user allowed
       e.g.
      SELECT PicklistShowID, PicklistFilterID FROM names n
      WHERE
      upper(n.USERID) = UPPER(#sq($account.personalInfo.userName)#  )

2. in any "picked" QS have a Where-Clause:
WHERE ...
NAME in ( #promptmany (  'Your names','character','','','[your_datasource].[PickList_Names].[PicklistFilterID]')# )