Reporting Directly Against a Transaction System
When you implement an ad hoc or business query tool, you may reduce report development costs, but you do nothing to improve query response time or provide meaningful context to the data. In fact, you run a high risk that you will make response time significantly worse for both BI queries and transaction system inputs. The simple answer is to build a data warehouse or a data mart. After all, the fundamental difference between these two platforms is their primary purpose: automating a process versus providing business insight (see Table 1-1 in Chapter 1). Yet many companies still elect to implement SAP BusinessObjects directly against the OLTP system (or a copy of it).
Why Use OLTP Directly?
A company ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
