Library

LeapFrogBI DWA Supports SQL Server 2017

Simple as that.  LeapFrogBI Data Warehouse Automation now supports SQL Server 2017.  Existing clients can upgrade their projects without writing a single line of code

Can Reporting Tools Alone Solve Your Reporting Challenges?

Reporting tools have become pretty good, and companies buy them with the expectation that doing so will solve their reporting challenges. But is this really the case? Are they really up to the job? This is a conversation we have frequently with clients and we hope it may benefit you.

Top 3 Data Warehousing Mistakes

Many organizations have built data warehouses successfully, and some have failed. There’s no reason at all for you to learn the hard way. In this

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