Process large jobs in batches using LeapFrogBI.
You select the grain (Year, Quarter, Month, Day, Hour, Minute), the start and end date, and whether or not to use a smart key as the surrogate. You can even use relative dates to help with situations where you want to grow the dimension on each execution. Finally, the LeapFrogBI d3000 template includes a set […]
The LeapFrogBI platform is constantly being improved thanks largely to user feedback. Here’s a quick recap of the top 10 enhancements of 2014 that you don’t want to miss! Faster Builds You will soon notice that your builds are completing much faster? LeapFrogBI hardware was upgraded on May 2nd to support rising demand while offering […]
Have you ever had the need to rollback your project to a point prior to the last load process? Well, it is easier than ever to do so with the Snapshot Rollback feature. Turn the feature on, and always know that you can roll the project back to the exact state that existed prior to […]
LeapFrogBI streamlines the creation, maintenance and sharing of a data dictionary. Simply provide a text description for components and fields online, and the rest is automated! Component and field descriptions will be stored in the target database as extended properties. All extended properties will be named ”MS_Description”. This is the same name used natively when […]
SQL Server 2014 has arrived with a very nice set of new functionality. LeapFrogBI projects can now be deployed to SQL Server 2014 by simply selecting your target platform. Already have a project set to deploy to an earlier version of SQL Server? No problem. Update the target platform, queue a build, and deploy!
LeapFrogBI supports a number of physical architecture options. Developers can select an architecture and configure each project as desired. Keep in mind that LeapFrogBI creates in-database (ELT) processing whenever possible. This means the database engine will be doing the heavy lifting regardless of the location of SSIS and package execution. When selecting a target architecture strive […]
LeapFrogBI’s out of the box reporting just got better. Precedence reports make load execution monitoring available to anyone with a web browser. Jump straight to job history and get details on any process. No coding required. Be sure to deploy the LeapFrogBI monitoring solution along with each project deployment.
There are many ways to deal with records that have been deleted from a source system. The first decision is to determine if the deletion needs to be reflected in the target model. Then we need to figure out how we will know when a delete has occurred and identify the deleted records. For an […]
What to do when a data warehouse source system deletes a record? There are probably hundreds of answers to this question. If you want to review a few of the options, then check out this post. For the sake of brevity, I am going to focus the situation as follows: The data source hard deletes records […]
Watch this short video to learn how LeapFrogBI is transforming traditional data warehouse development into a fast and flexible process.
Building anything from houses to software applications requires that we make decisions about how to efficiently convert raw materials into the desired product. Building a home in 1492 started by cutting down raw trees. Today builders use dimensional lumber or prebuilt partitions. Efficiency is gained by streamlining many of the tasks related to building with […]