-
Native Version and Custom Version Lists
Summary: This lesson discusses the two methods that Model Builders can use to build what-if scenarios - using Native Versions and using lists to build a Custom Version. Audience: Model Builders Lesson Duration: 6 minutes Lesson Location: This micro-lesson is also available in the Level 3 Model Building course in…
-
User Filters
Summary: This lesson demonstrates using a model's Users list as a dimension in filters to make criteria apply to a specific individual user. Audience: Model Builders Lesson Duration: 23 minutes Lesson Location: This micro-lesson is also available in the Level 3 Model Building course in the Learning Center. Start the…
-
Dependent Dropdowns
Summary: A dropdown list, or picklist, is a line item that contains items an end user can select. This lesson reviews dependent dropdown lists - in which the selectable items are filtered based on a second line item. Audience: Model Builders Lesson Duration: 8 minutes Lesson Location: This micro-lesson is also available in…
-
Uses of the User List
Summary: A model’s Users list can be utilized to do more than just grant access to the model. This lesson provides an overview of other ways in which a Model Builder can employ the Users list. Audience: Model Builders Lesson Duration: 6 minutes Lesson Location: This micro-lesson is also available in the Level 3 Model…
-
Clearing Module Data
Summary: This lesson discusses the use of a staging module to allow end users to input data and then be cleared for re-use. Audience: Model Builders Lesson Duration: 13 minutes Lesson Location: This micro-lesson is also available in the Level 3 Model Building course in the Learning Center. Start the Micro-lesson:…
-
Compound Functions: SUM, LOOKUP, SELECT
Summary: This lesson provides guidance on creating formulas that use combinations of SUM, LOOKUP, and SELECT functions. Audience: Model Builders Lesson Duration: 7 minutes Lesson Location: This micro-lesson is also available in the Level 3 Model Building course in the Learning Center. Start the Micro-lesson:…
-
Handling Exceptions
Summary: This lesson discusses model design considerations for addressing exceptions within a business process. Audience: Model Builders Lesson Duration: 3 minutes Lesson Location: This micro-lesson is also available in the Level 3 Model Building course in the Learning Center. Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For…
-
Using ISFIRSTOCCURRENCE with Transactional Data
Summary: This lesson explains how the functionality ISFIRSTOCCURRENCE can be used to identify the first occurrence of an item. This functionality is useful for moving transactional data from a data hub to spoke models. Audience: Model Builders Lesson Duration: 3 minutes Lesson Location: This micro-lesson is also available…
-
Converting Data Formats
Summary: This lesson reviews best practices for transforming data from one format to another to use a specific function. For example, converting text to a date or a date to a number, to use it as source data or for mapping in a formula. Audience: Model Builders Lesson Duration: 4 minutes Lesson Location: This micro-lesson…
-
Data Staging - the Good, the Bad, and Why it Matters
Summary: This lesson provides guidance on effective ways of staging data in a data hub. Audience: Model Builders Lesson Duration: 5 minutes Lesson Location: This micro-lesson is also included in the Setting Up a Data Hub course in the Learning Center. Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For training purposes only.…