Takes too long to build a new adhock report
Aimed at C Level and not operational management
Great Graphics shame about the numbers
New security has to be applied
BI systems have changed dramatically over the last few years and there are now two types. The old fashioned system that uses an OLAP database that extracts data from the transactional database using an ETL tool. Then the newer, modern systems that run in-memory and use a column store index that can run directly off the transactional database and run consolidations across dimensions very quickly.
Pros and cons of using them for operational reporting.
BI systems have changed dramatically over the last few years and there are now two types. The old fashioned system that uses an OLAP database that extracts data from the transactional database using an ETL tool. Then the newer, modern systems that run in-memory and use a column store index that can run directly off the transactional database and run consolidations across dimensions very quickly.
Pros and cons of using them for operational reporting.ass red7
Due to the innate complexity of BI systems, a new reporting requirement will typically require 2-3 man-days to design and implement. Depending on the level of resource available, it can take many more days or weeks to schedule in this time. This then forces operational management to take things into their own hands and start to build data shadow systems in Excel.If we now look to the new in-memory BI systems you have similar problems to traditional BI systems, but the key issues are;
