Cognos tidbits: Difference between revisions
Jump to navigation
Jump to search
(new page) |
(No difference)
|
Latest revision as of 20:54, 19 December 2008
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')#