-
String Concatenation
Summary: Concatenation is the process of combining two text-formatted line items or strings together to make one result. It can be accomplished multiple ways in a model. This lesson reviews how to optimize concatenation to reduce the impact on a model's processing speed. Audience: Model Builders Lesson Duration: 9 minutes…
-
Working with Ranges, Tiers, or Bands
Summary: This lesson demonstrates how to avoid long formulas when identifying if a value falls within a range of values, which are referred to as tiers or bands. Audience: Model Builders Lesson Duration: 5 minutes Lesson Location: This micro-lesson is also a course in the Learning Center Start the Micro-lesson:…
-
End User Filtering with Published Line Items
Summary: In this lesson, you’ll learn how to set up your model so that end users can filter a dashboard grid with published line items that set the filter criteria. Audience: Model Builders Lesson Duration: 16 minutes Lesson Location: This micro-lesson is also a course in the Learning Center Start the Micro-lesson:…
-
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 a course in the Learning Center Start the Micro-lesson:…
-
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 a course in the Learning Center Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For training…
-
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 a course 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 a course in the Learning Center…
-
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 a course in the Learning Center Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For training purposes only.…
-
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 a course in the Learning Center Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For training purposes only. Not…
-
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 a course in the Learning Center Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For training purposes only. Not for use…
