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
9993 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

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

3 Answers CTS, TCS,

How many number of cubes can we create on a single model? How can we navigate between those cubes?

2 Answers

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

1 Answers IBM,

------------ Diff b/w MemberCaption and MemberDescription?

0 Answers

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

0 Answers

How to select multiple values from type-in prompt?

0 Answers

I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?

1 Answers Facebook,

In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,

2 Answers Tech Mahindra,

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers

-----------Types of Fact Tables?

6 Answers Bank Of America, CTS,

1. Differences between Merge and Union In Cognos?

0 Answers Wipro,

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers

For more Cognos Interview Questions Click Here