Part of the beauty of using LeapFrogBI to define your data mart is how easy it is to make modifications. One example of this is the ”Redirect Source” feature. With this feature a component’s source can be changed by simply selecting the new source component and mapping new source fields to each of the old source fields that are in use. To initiate a source component change simply go to the component’s detail page. Directly above and to the right of the field list will be a link titled “Redirect Source”. After clicking this link you will be presented with a form (below) which will allow you to specify the new source component and map new source fields to all required redirects. You must map all required fields prior to saving the redirect. Otherwise a validation error will be returned such as below. See end of this post for all validation rules related to redirects. The below image shows how components in a typical data mart are dependent upon each other as either a source or a destination. LeapFrogBI ensures that this lineage is never broken. However, it is often necessary to change a component’s source. This is what is referred to a redirect in LeapFrogBI. In this example, the red PSA component uses the purple stage component as its source. All of the green components are dependents of the red PSA. Let’s assume that we need to adjust to a change in the source system. To do so we need to profile the new source and create a new stage (light purple stage). It would be a real pain to rebuild the seven components that are dependent on the existing stage (dark purple) just to account for a source system change. This is where the ”Redirect Source” feature comes in very handy. All we need to do is redirect the red PSA to the new Stage (light purple) component. After completing the redirect, we can delete the old stage if it is no longer needed. The redirect is now complete. When the Stage and PSA component are deployed the changes will be in place. You may notice that we did not worry about connection information. LeapFrogBI will ensure that all of the connection information is sourced from the appropriate component without any action on the developer’s part. Validation Rules LeapFrogBI enforces a few validation rules to ensure the integrity of the system.
- The new source component cannot be a dependent of the current component
- Appropriate component types will be available for selection. (PSA cannot redirect to a Dimension)
- Old source component fields that are used must be replace by fields in the new source component
- When mapping fields the old and new field data type must match