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
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!
You will soon notice that your builds are completing
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
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.
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
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
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
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
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