Components are typically unique and apply only to a particular unit of work. The component's source contains a unique set of outputs and the component exposes a transformed set of output. However, there are some cases where a component can
Tips & Tricks
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 to upload or input data into a web browser efficiently. Examples include; multi file stage,
Some users love being notified when build jobs complete, and others hate it. Good news! Users can now enable or disable build email notifications in the user settings area. Simply check the box; or not.
The precedence solution makes executing & monitoring a LeapFrogBI project deployment a simple and fast task. To configure your project’s precedence and notification settings navigate to the precedence page in the deploy menu. Detailed instructions are included on each required
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
After you deploy a LeapFrogBI project, you will need a way to monitor the load process. The LeapFrogBI monitoring solution provides monitoring and much more in the form of a pre-built SQL Server Reporting Services project. Like all other LeapFrogBI
Building data marts in an agile manner often means that iterative enhancements will be deployed. Each deployment is aligned with a set of requirements which may require that the previously deployed data mart be altered to meet the new design
Project builds include all code in one archive for all project lifecycles. The build file, LFBI.zip, will contain all component packages in the root archive folder and lifecycle specific packages in correlated subfolders. See below images.
Users can queue a
LeapFrogBI manages the load process for each project by creating SQL Agent Jobs that are tasked with carrying out the execution process. You now have new options in the precedence settings that impact how the “Reset” job functions.