View source for Cognos tidbits

← Cognos tidbits

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page.

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')#'''''

Return to Cognos tidbits.

Retrieved from "https://www.chiplynch.com/wiki/index.php/Cognos_tidbits"