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 be applied to numerous data flows with only minor differences. Consider a data warehousing effort […]
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, and rest API collection. Excel workbooks include the option to automatically “Calculate Workbook” when the […]
This quick tip demonstrates how to create a data flow queue using LeapFrogBI.
Process large jobs in batches using LeapFrogBI.
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 input. Simply update your solution, save the settings, and your ready to build & deploy! […]
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 […]
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 generated assets there is no post deployment dependency on LeapFrogBI. The monitoring solution may be […]
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 & functionality. LeapFrogBI automates the tasks required to compare the deployed schema to the current […]
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 build which either includes or excludes a project build by enabling or disabling the project archive […]
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. Scheduling Options – The reset job schedule can now be set in the project precedence settings. You […]