Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Operational and analytical reporting

2 posters

Go down

Operational and analytical reporting Empty Operational and analytical reporting

Post  umutiscan Wed Sep 18, 2013 7:01 am

We are discussing reporting responsibilities of IT departments of my company. Traditionally we group reporting needs under two main category : Operational reports and analytical reports.

Operational reports (like tickets waiting for an action) are generated to support intra day operations of operational departments so we address this kind of requirements to operational systems or operational data store. Because wee need near real time reporting capalities to meet intra day reporting needs. On the other hand, analytical reports (like trends, monthly or yearly aggregations etc) are addressed to data warehouse. Briefly we have 3 potential reporting environment : ODS, data Warehouse and operational systems.

But we are discussing the address of some type of reports. I listed some examples below and I wonder your opinion.

- Monthly debit card transaction list of a customer : Real time capabilities not needed, this is used for monthly analysis or controls. And I already have those transactions in data warehouse, because I use the transaction list to generate transaction aggregations. And transaction level data in data warehouse is available for reporting. But some people think that this report is a very "simple" report, I mean it has no analytical content, so it has to be addressed to ODS or operational systems. But I think  "Simple report" is not equal to operational report and "real time need" is the key indicator to differentiate the operational report and analytical report. So this report must be addressed to data warehouse.

- Monthly Legal Reports : This kind of reports are prepared by source systems. But generating monthly reports on operational systems is an hard work, summarized data has to be stored for a long time, and those reports are generally aggregated and summarized by customer id. So I think that this kind of reports must be handled in data warehouse.

Thanks in advance.


Posts : 51
Join date : 2010-11-26
Age : 43
Location : Istanbul, Turkey

Back to top Go down

Operational and analytical reporting Empty Re: Operational and analytical reporting

Post  ngalemmo Wed Sep 18, 2013 10:49 am

It really depends, but if you can do it from the DW, that's fine.

The 'legal' reports may be an issue. GAAP suggests such reports originate from the system of record. This usually means the system that processed the transactions. You can work around it by implementing tight controls on the ETL process to ensure the DW image is accurate and current. This would need to be addressed by the CFO.


Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum