Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?

Answers were Sorted based on User's Feedback



if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used ..

Answer / rizwan

hi buddy use ?promptname? in sql

Is This Answer Correct ?    6 Yes 1 No

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used ..

Answer / the_xxx

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

Is This Answer Correct ?    2 Yes 0 No

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used ..

Answer / mac

Suppose u have a prompt which has country code, u can use
that parameter in ur sqls to filter particular contry's
details.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer



More Cognos Interview Questions

What is difference between drill through and drill down?

5 Answers   IBM,


How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,


What is called materialized view?

0 Answers  


Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,


5. Which type of report you build more, list, crosstab or chart and why?

0 Answers   IBM,






How do you test the performance of a report?

3 Answers   TCS,


difference between boxtype and visiable

1 Answers   IBM,


-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,


What is difference between page break and section report?

0 Answers  


------------------What is Inline Query?

0 Answers   Cap Gemini,


wat is called Model dimension?

0 Answers   IBM,


how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

3 Answers   TCS, Thomson Reuters,






Categories