Hey, so I finished training for Framework Manager Cognos 11 and I'm struggling to create a picklist style prompt. For example, I want to create a prompt where the user can select one or more choices from a list. In this case, Division (010, 020, etc.). I've tried doing
#promptmany('Select Division(s)', 'memberuniquename', '[namespace].[dimension].[division].', '', [namespace].[dimension].[division]')# along with other ways.
I know the 3rd parameter should be a default MUN and then you need the source of the members. I write this as a filter. I've also tried in the query subject definition [.....where DivisionCode in (#promptmany(...etc)] But every time I publish and try the prompt on Analytics, I get a prompt where you type in a value with a blank list next to it.
What am I doing wrong? Is there another step? Thanks