COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: zealkarthick on 08 Nov 2011 06:46:39 AM

Title: Regarding OLTP DB Reporting
Post by: zealkarthick on 08 Nov 2011 06:46:39 AM
Is it a good practice to have cognos repoting system from the operational Database whic is totally normilized
Title: Re: Regarding OLTP DB Reporting
Post by: yogesha on 08 Nov 2011 07:47:08 AM
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.


Title: Re: Regarding OLTP DB Reporting
Post by: zealkarthick on 08 Nov 2011 11:03:23 PM
what about the performance of report on olpt source when compare to olap or a modeled data
Title: Re: Regarding OLTP DB Reporting
Post by: blom0344 on 09 Nov 2011 02:39:22 AM
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