If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Regarding OLTP DB Reporting

Started by zealkarthick, 08 Nov 2011 06:46:39 AM

Previous topic - Next topic

zealkarthick

Is it a good practice to have cognos repoting system from the operational Database whic is totally normilized
Karthik

yogesha

Normally, we will not do this. Because, data will not be in transformed in operational DB.So,we cant deliver the report as BI requested.

If we don't have time for ETL. We can build reporting system on operational DB.



zealkarthick

what about the performance of report on olpt source when compare to olap or a modeled data
Karthik

blom0344

This would largely depend on the type of report/queries involved. Allowing the casual user to develop their own reports against OLTP is probably the biggest no-no. Otherwise some carefully designed reports which are thoroughly tested prior to production phase may be perfectly acceptable