LeapFrogBI projects include the option to enable automated notifications per lifecycle based on load process events; start, complete, and failure. To setup the solution simply navigate to the precedence page in the deploy menu, expand the Notification section, and fill out the configuration options. The precedence solution’s poll job controls the notification process by executing bi_notify.dtsx.
Monitoring a data integration process can be a time consuming task. With the new automated notification system email notifications can be sent to alert administrators of load events. A flexible configuration definition and one click deployment makes setup a cinch.
A quick Google search on “Failed BI Project” will yield more results than any normal human can read in a lifetime. Sure, many of these results are the product of marketers playing the fear angle, but there is also some very valuable content written by people with real world experience. A common theme exists which […]
What is an inferred member? What is an unknown member? Early arriving facts or late arriving dimensions require that fact record foreign key values be uniquely managed. In this video we cover a few common options.
What is a surrogate key? What is a foreign key? What is a business or natural key? It is important to know the meaning of these key types and others to effectively design and read dimensional models.
Loading a data warehouse requires that a mechanism be created for tracking which source system records have been processed and which are pending. ETL & ELT are very custom processes, but general design patterns are often repeated. In an ideal situation the data integration process will possess these traits: Collection of source system records can […]
User feedback on the new interactive graph feature has been extremely positive. By popular demand, interactive graphs are now also available in component details! Also, the component selection console has been added making it extremely easily to navigate between components without exiting the details context.
LeapFrogBI now offers project navigation via interactive graph visualizations! Simply go to any component and you will be presented with a graph representing the upstream and downstream components related to the selected components. Want more detail? No problem – check the “Extended Map” option and the graph will display all related components recursively. Still not enough? […]