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 is a Query Subject?

1033

Is it possible to join multiple Databases in a Catalog?

1060

What is the use of report studio?

975

what is degenerate key in oracle ?whare do we use it?

2506

Which studio is used to create reports?

1059

how you migrate reports to cognos 8 from previous versions?

983

Can you define slice?

974

What are the roles defined by cognos platform?

1073

Can you define confirmed dimension?

1021

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1878

What are all the types of hierarchies?

1078

What is a Datastore in Cognos?

1225

Define metrics studio?

975

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4334

Tell me about Dnamic and Static Dashboards?

2271