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 / rizwan

hi buddy use ?promptname? in sql

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the errors faced while bursting the reports and how to solve those errors?

1565


-----------Diff b/w OLAP and RDBMS?

1620


What are the ways to import data into catalog?

633


What is the enterprise class platform architecture of cognos 8?

583


can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1707






Why is auto-regression used in forecasting used on cognos platform?

540


What is a Framework manager?

561


What is the function of model design accelerator?

539


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

910


How to do Performence Tunning in Cognos Reports?

2077


What are types of batch available in cognos?

558


How we check the errors before running the report?

541


How create measures and dimensions?

605


When we save a report in report studio with what extn it save?

652


Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1474