Can we create reports using OLTP database?How?

Answers were Sorted based on User's Feedback



Can we create reports using OLTP database?How?..

Answer / m.upendra raju

yes we can create reports using OLTP databases.But the
thing is we need to import tables into framework manager
and create a model and package and publish that into Cognos
portal for report authors to create reports in report
studio and query studio.

Is This Answer Correct ?    11 Yes 0 No

Can we create reports using OLTP database?How?..

Answer / praveen

yes we can create reports

Is This Answer Correct ?    5 Yes 0 No

Can we create reports using OLTP database?How?..

Answer / vinod kumar reddy

we con't create reports from OLTP databases, but we can
import query items from data source it means with out
modeling, it is possible in cognos 8.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Cognos Interview Questions

how u migrate the reports from impromptu to reportnet???

3 Answers   Wipro,


What is metric studio?what is score cards and how to implement score cards what is the use of score card?

1 Answers   IBM,


can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,


Can you define a catalog and types of catalogs in cognos?

0 Answers  


can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,






I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,


What are Governer Settings?

2 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,


actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?

1 Answers  


What is a Cube?

0 Answers  


----------------What is Surrogate Key?

1 Answers   Cap Gemini,


hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  


Categories