top of page
Training Videos
020.090 Record Governance
This video discusses the concept of Record Governance within system architecture, addressing its significance and implementation. The agenda covers the fundamental definition and necessity of Record Governance, contrasting its approaches in the old and new paradigms. Understand how, in the new paradigm, systems automatically govern records, facilitating transferability and simplification through a master data server. Explore practical considerations for the front-end, functions supporting Record Governance, and potential future developments. We'll also delve into the benefits of Record Governance, emphasizing its critical role in maintaining data integrity and supporting diverse governance structures in the same table with minimal overhead. The video concludes with a straightforward summary, providing insights into the nuanced world of Record Governance.
020.100 Data warehouse generate
The 3D Enterprise Platform is designed from the ground up to be able to automatically aggregate data from business unit systems into a data warehouse. This feature addresses the insurmountable challenges we have cleansing and aggregating data from disparate systems for reporting and AI.
020.110 Master Data Query
In this video, we explore the practical significance of Master Data Query. Master Data Query is a new approach to querying enterprise databases that allows users to quickly pull all data related to any subject in the enterprise database. The benefits of Master Data Query are transformative, facilitating quick data aggregation for informed decision-making. This video aims to provide a pragmatic understanding of Master Data Query, its development journey, user interface implications, and its integral role in shaping the future of enterprise systems. Join us as we uncover the practical applications of Master Data Query in the modern enterprise landscape.
020.120 Financial Module
Explore the revolutionary Financial Module in this video, reshaping enterprise architecture. Dive into its goals, triggering a paradigm shift in financial systems by addressing issues like sub-ledger disconnections and data duplications. Delve deep into financial procedures, uncovering the creation of new-gen routines for tasks like setting up batches and generating revenue journal entries. Discover benefits such as streamlined year-end closings, improved audit trails, and data import capabilities. The normalized data structure minimizes account proliferation, fostering code sharing and cost reduction. Real-time linkages with temporal data and advanced analytics offer a comprehensive view of financial dynamics. Join us to unravel the transformative potential, flexibility, efficiency, and enhanced data integrity of the new-gen Financial Module.
020.130 Regen Environment
This video describes the procedure for generating a new enterprise system platform based on a revised data dictionary. The process involves creating a new database structure, converting data into it, generating integrity rules (foreign keys, duplicates, etc) generating views and then going through the two test environments.
020.140 Application Framework
In this video, the architecture of a global enterprise system network is outlined, with a focus on an innovative application framework. The framework's goals encompass cost reduction, extended system life, and simplified modifications, distinguishing it from older paradigm frameworks. Key features include robust authentication, menu hierarchy, search/browse, edit forms, workflow capabilities, and more. The presentation also covers the significance of the data model and effective release management, enabling the creation, modification, and application of scripts to any environment. Additionally, the framework allows for sharing modules between systems, facilitating new module development, feature isolation, and updates. The associated benefits include prolonged system life, enhanced interfaces, consistency, and the ability to import modules from software providers, making this framework a valuable advancement in enterprise system development.
030.010 Database design Introduction
This video describes the topics that will be discussed in the database design section.
030.020 Multilink join
In this video, we unravel the intricacies of Multilink joins in database design. The agenda kicks off by exploring what Multilink joins entail and why they serve as a distinct alternative to regular joins. Delve into real-world examples like activities, rates, and attributes, understanding the challenges they present and how they are accomplished. Uncover the need for specific functions to support Multilink joins, such as sysForeignKeyCacheRefresh and sysViewCreate. Explore user interface considerations, where Multilink joins can be driven by other columns like GL Account or Activity Type. Discover the benefits of Multilink joins, enabling the creation of common utilities without the need for database modifications and ensuring efficiency. The video concludes with a concise summary, encapsulating the key insights into the world of Multilink joins in database design.
030.030 Recursive Structures
In this video, I discuss the complexities of recursive structures within database design. The agenda unfolds with an exploration of what recursive structures are, their conventional implementations, and examples in various contexts such as Activity Types, HR Structures, and Fixed Asset Types. Dive into the mechanics of recursive selects, understanding top-down, drill-down, and bottom-up queries, along with identifying recursive loops. Explore user interface considerations that involve displaying tree structures, enabling drill-down from any level, and dynamically changing tree structures. Discover the concept of recursive many-to-many relationships and the inherent benefits, such as flexibility, effective drill-down, and data integrity. This video provides a comprehensive overview of the nuances of recursive structures, emphasizing their natural expression of data and the advantages they offer in database design.
030.040 Sub-typing
In this video, we delve into the practical aspects of database design, specifically focusing on subtype structure. The agenda includes an exploration of what subtype structure entails, the various ways it can be implemented, and real-world examples for context. We'll discuss the implications of not using subtyping, including increased complexity and limitations in flexibility. Considerations such as over-subtyping, entity relationships, record governance, and temporal aspects will be explored. Discover the benefits of subtype structures, like cleaner database designs and improved support for record governance rules. The video concludes with a straightforward summary of the key insights discussed in the context of subtype structures in database design.
030.050 Core Models
This video delves into the fundamental concept of core models within enterprise systems, focusing on Contact, Activity, Fixed Asset, and Finance models. The agenda unfolds with an exploration of what core models entail, their handling in the old paradigm, and a detailed examination of each specific model. Discover how core models manage universal organizational data, facilitating the exchange of information between systems and allowing for augmentation to address unique needs. Learn about the evolution from the traditional approach of ERP vendors to the more aggregated and flexible approach of our innovative system. The video concludes with a discussion of future models, the numerous benefits these core models offer, and a comprehensive summary of the key insights covered in this exploration.
040.010 Stage 1 Test Environment Test Case
This video describes the environment that was created for regression testing the platform
bottom of page