Author: Paul B. Felix

Precedence Field “JobNotify” Legend

The field [dbo].[Precedence].[JobNotify] in the LeapFrogBI console database is used by the poll job to determine which email to send and when to send it.  The package named “BI_Nofity.dtsx” (step 2 of the poll agent job) consumes and sets these values.  Here’s what the values represent.

Bridge Tables

Dimensional modeling (DM) places and emphasis on the end user’s experience.  The goal is to create a data model that performs well and is simple

Dimensional Modeling: Introduction

What is a dimensional model? What is a data warehouse? This video introduces dimensional modeling while setting the stage for the series of dimensional modeling training videos to follow.

Calculate Workbook

When using several of the LeapFrogBI component types, configuration information is stored in Excel.  This architecture is used in cases where it is not feasible