Paul B. Felix, Author at LeapFrogBI

Deploying Component Modifications

The LeapFrogBI platform provides a toolset that not only streamlines initial data mart deployment, but also greatly simplifies incremental modification tasks. There are a few

Dimension Load Using the MERGE Statement

The T-SQL MERGE statement was introduced in SQL Server 2008, and in many ways simplified common tasks such as dimension loading. However, like most things

Schema? Prefix? Both or None?

When building SQL Server data warehouses should user-defined schemas be used? Should tables and views be prefixed? Or, maybe we should do both. After talking

Loading Dimensions From Multiple Sources

Dimensions records are often derived from multiple sources. When these sources are in sync, it is a simple enough process to combine the sources to

Existing Template Source SQL

The LeapFrogBI DWA platform enables the use of existing tables and views. For example, when extending a data mart there will be existing dimensions that

Record DateTime Explained

When creating a PSA component, the designer is asked to assign a value to RecordDateTime. The selected value will have implications downstream on both fact