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

How can I test reports in cagonos?

0 Answers

What is metric store database?

0 Answers

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

1 Answers HCL,

In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers Wipro,

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers BitWise,

Can we create reports using OLTP database?How?

3 Answers

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

0 Answers Accenture,

In framework Manager, what is a stitch query and is it good or bad?

2 Answers Polaris,

What is zero-foot print?

0 Answers

-----------What is member Description?

2 Answers

For more Cognos Interview Questions Click Here