Data Changes in Source Systems Cause Disaster in Business Intelligence Reporting

Every change in source systems directly related withnot possible to stop processes since company lives
reporting systems, specially Business Performancefrom them and they are more important. As an
Management Software can cause official external andexample, company cannot stop new marketing
internal reporting collapse. What may seam like smallcampaign of new product line because it will cause
change in only one table in sources like change inreporting inconsistency...
customer hierarchy of one larger customer couldSolution for business intelligence reporting problems
cause distorted or no data at all in reports if thecould then be development of parallel reporting, live and
change is not predicted in company informationoff line reporting. Live reporting systems take live data
system (IS). For example, finding different businessfrom systems. This data are usually nonaligned
segments of daughter companies beneath residentialreporting data - KPIs for reports. Off line reporting
customer. Obviously it is a mistake and needs to bemeans to take data from sources in the old way, with
cleaned. Misinterpretation of content in one table inold ETL or with code change to compensate change
data mart or in data set can cause false publishing ofin sources. Old ETL or code patch will cause stability
all reports related to customer segmentation in thisof reports for a while. Management hates parallel
case.reporting approach since that could mean lot of
Small change can have significant impact in caseproblems in interpretation of data and causes data
when employee goals depend on key Performancemisinterpretation throughout complete company.
Indicators (KPIs), budget realization, reporting towardManagement argues about "same" KPIs whose KPI's
stock exchange, auditors and etc. Those reports areare more accurate. From different reporting systems
published and can not be historically revised. And allmanagers could have taken KPIs from off line
named problems might be consequences of only onereporting, some managers from live reporting and
small change in content of data of only one sourcesome even from a combination of both. Parallel
system... Sound absurd, specially from process ownersreporting leads to many problems and more
side but it is true.engagement of resources for maintenance. This is not
Real problems begin if it is not possible to stopan ideal solution instead of releases but is there any
changes. Sometimes systems are not designed andbetter solution how to handle changes in source
structured to handle releases of changes andsystems and making problems in business intelligence
therefore can not implement changes in releases. It isreporting?