hi buddy use ?promptname? in sql

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

Answer Posted / rizwan

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are all the components of Report Studio?

1087

What is the difference between regular dimension and derminant?

2264

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2011

-------------What is Coditional Prompting?

2141

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1920

how to explain health care project and which reports we can create in health care doain?

6796

What is the difference between set functions and filter function in dimensional data?

2896

Can you define drill down and drill up?

1029

How security is concerned with Reportnet? Explain its implementing steps.

2030

Name the types of report?

946

What are the ways to import data into catalog?

1078

How do you Parametermap variables in Quiries?

2252

what is the difference between native sql and cognos sql?

988

tell me two or three issues from client side and how to solve those issues?

2160

What is a Datastore in Cognos?

1280