Cognos tidbits
Jump to navigation
Jump to search
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')#