1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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?

Question Posted / kumar

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 stitched Query?

5 Answers  

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

4 Answers   IBM,

Can we test the report other than manual testing?

0 Answers  

how to create cubes in transformer ?

0 Answers   IBM,

If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 Answers  




How can I change reports to another package???

3 Answers   IBM,

what is the different between primarykey and surrogated key.. why we are going for surrogatekey...

1 Answers  

What are all the types of indexes in Cognos?

0 Answers  

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

5 Answers   IBM, Virtusa, Wipro,

how to perform single sign in cognos by using url?

0 Answers   IBM,

---------- Purpose of Factless Facttable?

2 Answers   Bank Of America,

What is main advantage datawarehousing over oracle?

0 Answers  

For more Cognos Interview Questions Click Here
Categories