For many companies, traditional business intelligence (BI) software is costly and resource-intensive. So are open source alternatives that require significant configuration and integration. In contrast, software-as-a-service (SaaS) solutions can reduce the cost of a BI deployment by providing automation and pre-integration. Compare total cost of ownership (TCO) for traditional, open source, and SaaS BI solutions.
check in check out of documents
expensive to set up (checksum and other schemes can be deployed to ensure only the records that changed need to be updated.) Adding additional fact metrics - for transactional information that needs to be aggregated, making sure that new items (like orders, shipments, etc.) are added to database. Recording historical snapshots - being able to properly record snapshots of various attributes. This requires being able to save many versions of a given record (say, for example, a customer record where their