Design patterns greatly speed development. The DP3000 & DP3100 design patterns create a data flow which tracks the current version of records in PSA based on a selected key field. The result is a new field in PSA called isCurrent
Trim both sides of a string in one step using the new Left Trim & Right Trim combined expression type.
Custom Connection Attributes
This new feature adds a connection attributes dialog to connection string definitions enabling users to define custom attributes at design time.
Faster Access to Generated Code
Users can now view generated code, download a build (save or
Have you ever wanted to just type some t-sql instead of using the fully validated LeapFrogBI expression builder? Well, you are in luck. You can now do just that! Simply select the custom expression option in the expression builder and
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.
New project level build option! 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. Users can
Users will now receive an email notification when a requested build is complete. Simple & Effective.
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.
The bulk profile feature now supports two additional component types; Existing Stage and Existing Transform. At times you may need to consume data that has already been collected by processes outside of LeapFrogBI. The “Existing” type templates enable you to
A new dimension template, D1004, is now available. Here’s the description:
“Create a dimension using existing PSA or Transformation components as a source. All dimension attributes must be tracked SCD 0 or SCD 1. Metadata fields such as Start, End,