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 by default which identifies the current PSA record with a value equal to 1.At times […]
Users can now view a visual representation of functional constraints via the Precedence Graph option.
At times it is useful to retrace your navigation steps within a project. Now you can.
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 execute), view build status, and refresh generated code (build) directly from the component detail page. Can it get any easier?
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 paste in your t-sql.
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 queue a build which either includes or excludes a project build by enabling or disabling […]
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. Scheduling Options – The reset job schedule can now be set in the project precedence settings. You […]
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 profile an existing source, and use it just as if it was created by LeapFrogBI. […]
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, Current, and LoadTime are not included in this template. This template also provides the ability […]