There is a perception that if business users are given access to enterprise databases and raw query tools, they will create havoc in the system, which is a possibility—unless the business intelligence (BI) product developer understands the potential problem and addresses it as a business-critical factor.
system user access
everything in the same system or in the source instance where the transaction occurred, the users can actually drill through a transaction and fix the error on the spot if something is wrong. Furthermore, as the Sarbanes-Oxley (SOX) and other reporting requirements hold businesses to higher standards of accuracy and accountability, business transparency is vital, but a DW, by definition, is a copy of the original data records. DWs are constantly being shifted, updated, or consolidated, and they combine