Cognos tidbits

From ChipWiki
Revision as of 20:54, 19 December 2008 by Chip (talk | contribs) (new page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump 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')#