if we have a value prompt in a prompt page and if we need
to pass that prompt value to a sql used in report, what is
the sql code? give me example?

Answer Posted / the_xxx

You can use the below macro (#prompt("dataitem")#)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

---------------Describe OLAP Reporting and RDBMS Reporting?

1660


What do you understand by the term 'aggregate advisor?'

534


What is a Cube?

680


what are the names of the reports that you prepared?

617


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

1688






Diff b/w Crossproduct and Outerjoin?

1808


How to Reset Pagenumbers in one report.

2203


What is defined as catalog and types of catalogs in Cognos?

557


What is the size of the cube?

527


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1650


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1865


difference between impromptu and cognos8

1963


Can you define materialized view?

608


What are the other methods working as deployment functionality?

513


What are all types of Batches?

567