Suppose u have a prompt which has country code, u can use that parameter

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

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

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.

1874

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2337

What are shortcuts? Where it can be used? What are the advantages?

989

Write some methods to apply securities in framework manager model?

1045

how to merge 2 crosstabs thans

2585

Why is auto-regression used in forecasting used on cognos platform?

949

How do you call a store procedure within a transformation?

938

Can you define cognos powerplay?

1031

write a query to display the departments with no employee?

1915

Why need staging area database for dwh?

1024

in u r data u having duplicates how to fetch the latest data in our report?

5631

what is requery in cognos?

2443

What are all the components of Report Studio?

1041

how to perform back drill through in cognos 8 what is the use of it

2464

what is power prompt in cognos ep7series?what is the use of this?

3623