Making the most of Business Intelligence
Comments
If an enterprise is going to integrate its Business Intelligence, the core of that BI model needs to be a record of the actual financial transactions that the company is involved in -- a subject that has been heretofore left to accountants.
If the Business Intelligence is organized around multidimensional (OLAP) databases, the core dimensions need to be the time and the debit and credit accounts affected by the transaction.
An accounting journal has always been a historical database of the company's business. We now have the technology to implement that journal (or a backup version of that journal) as a true OLAP database, allowing us to produce financial statements on a real-time basis and with simple SQL queries.
Other dimensions, such as business unit, product, customer, and activity type would allow us to turn the traditional accounting information into a powerful business intelligence system.
See my blogs on www.taodata.com.





