Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

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

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,

what is the difference between rollup aggregation and aggregation ?

1 Answers  

How to create users and permissions in cognos?

4 Answers   IBM,

Can we create a web page where the report directory and the output can be viewed directly across cognos connection?

2 Answers   TCS,

I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?

2 Answers  

what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

0 Answers  

what is online view?

0 Answers   HCL,

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

0 Answers  

What is limited local? and the uses?

2 Answers   Ness Technologies,

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories