Cognos tidbits

To insert a single-select prompt value anywhere in a manual SQL statement (such as in a nested subquery) in Cognos 8, use the following syntax:

where fiscal_year_number = #prompt('YEAR')#