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

Prompt Macro w/ default filter

Started by aolevano, 06 Aug 2010 11:31:27 AM

Previous topic - Next topic

aolevano

Hi all
This is my 1st attempt at a macro in FM - I'm trying to create a prompt with a default value.  I want the default value to be filtered by a session parameter.
I have tried a number of things that all lead to 1 error or another.   This is what I currently have, which seems to make sense in the macro editor, but errors when testing.  Any help is appreciated.


#prompt( 'pBldg ', 'integer' ,  ' where LOGIN_ID =  '  + sq($account.personalInfo.userName) )#


PS - this reades the UserName parameter correct, but throws a syntax error when testing