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

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

3 Answers
9805 Views
ComNet, I also Faced
E-Mail Answers

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

Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers IBM,

How to create a dynamic column name in Cognos?

6 Answers Aditya Birla, Polaris,

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers WNS,

----------------What is Surrogate Key?

1 Answers Cap Gemini,

What is minimum version of internet explorer to run the Cognos report.

3 Answers

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

1 Answers IBM,

can we create a chart without measure

3 Answers

What is Cardinality

6 Answers Cognizant, HCL,

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers

What is stitched Query?

5 Answers

How to create model and how to test model?

0 Answers

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

5 Answers TCS,

For more Cognos Interview Questions Click Here