SAP is now offering official product tutorials to assist in learning the latest SAP BusinessObjects 4.0 suite of products. Each product page acts as a dynamic library of material where content is added as it is created. Below is the list of products with available interactive and animated tutorials online. For more information on what’s […]
Oracle’s Business Intelligence Foundation is a complete enterprise business intelligence solution that delivers capabilities for reporting, ad-hoc query and analysis, OLAP, dashboards, and scorecards. In addition, the Oracle BI Foundation includes a common enterprise information model, which is a unified metadata model accessed by end user tools, allowing a “model once and deploy everywhere” paradigm. […]
Business Intelligence (BI) systems are software applications that enable better understanding of organizational data and provide the information organizations need to make enlightened decisions. Moreover, business intelligence systems are primarily focused on reporting, querying, and analysis of data residing in an enterprise data warehouse (EDW), and both dependent and independent data marts. Fundamentally, there are […]
The business intelligence (BI) software marketplace has seen a wave of corporate acquisitions since the mid 1990s with the size and importance of the acquisitions coming to their apex during the years 2003 – 2008. This surge in corporate activity in the mid part of the decade has been characterized by a number of large […]
By definition, a data warehouse appliance is a complete hardware and software solution that contains a fully integrated stack of processors, memory, storage, operating system, and database management software. The data warehouse appliance is typically constructed to be optimized for enterprise data warehouses, designed to handle massive amounts of data and queries, and designed to […]
Type Four – Insert Into a History Table Type four models, also known as leveraging “history tables”, is the most technically sophisticated of the four models and may be the most difficult to implement. This modeling technique provides for nearly unlimited tracking of historical records while having less storage requirement than type two models. Rather […]
Type Three – Leverage Previous and Current Value Fields Type three models are defined by adding one or more columns to the dimension table, so that the new (or current or active) and old (or historical or inactive) value of an field are stored. In addition, multiple previous values can be stored within the table […]
Type Two – Update Record to Inactive / Create an Active Record Type two modeling is a very reliable and straightforward technique for preserving history of changes to dimensional tables. It is commonly utilized when a full or partial set of the previous values of a dimension’s attributes must be retained. In type two modeling, […]
Type One – Overwrite the Record Type one modeling of slowly changing dimensions is very simple and effectively handles updates to incorrect and/or outdated values within the dimension table. Type one models do not retain a history of changes and do not store previous values in any way. With this modeling technique, the data field […]
Modern data warehouse design assumes that business transactions such as sales, orders, shipments, fulfillments, and receivables can occur at a rapid rate and each the details of each transaction needs to be recorded. Hence a fact table with a dimensional model contains a separate record for each business transaction. While in contrast, the describing or […]