how the values be passed to prompts in report studio?
when a data item is dragged n dropped in to report, after
the default query generated first which sql will the query
query hit for processing means (native or cognos)?
plz answers to these questions?

Answers were Sorted based on User's Feedback



how the values be passed to prompts in report studio? when a data item is dragged n dropped in to r..

Answer / ch8nya

1.before executing the query.
2.first cognos sql generate

Is This Answer Correct ?    0 Yes 0 No

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to r..

Answer / kumar

Hi Friends,

In Cognos We have 3 Kinds of SQL's

1) Cognos SQL --Default in Report Studio, Frame Work Manager.
2) Native SQL
3) Pass Through SQL

The Default SQL is Cognos SQL why it is It can be used to
create New Query Subjects or Edit , change existed.
it cal hold multiple data bases Query where Data Source
Query can be used for that specific DB.

Is This Answer Correct ?    1 Yes 2 No

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to r..

Answer / vinay kumar

create list report drag and drop the report and genrate the query... in cognos

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More Cognos Interview Questions

What is Outerjoin?

2 Answers  


How many fact tables you have in your project?

1 Answers   HCL,


can we join 2 different queries? One has 10 columns and other has 5+ columns?

2 Answers   IBM,


suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  


1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

1 Answers   CTS,






Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development

11 Answers  


what use of surgate key in project

3 Answers   HCL, TCS,


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,


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

0 Answers  


what is report studiio and how to start it?

2 Answers  


What is the advantage of using shortcuts?

0 Answers  


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

0 Answers  


Categories