-
Dynamic Cell Access
Summary: This lesson describes how a Model Builder can use Dynamic Cell Access to adjust permission levels for individual line items within a model. The lesson also includes examples from the DCA Learning App available in the App Hub, and best practices for creating Access Driver modules. Audience: Model Builders Lesson…
-
Writing Test Scripts
Summary: This lesson reviews best practices for writing effective end user test scripts and how to prepare for User Acceptance Testing (UAT). Audience: Model Builders Lesson Duration: 5 minutes Lesson Location: This micro-lesson is also available in the Level 2 Model Building course in the Learning Center. Start the…
-
Dimension Order
Summary: In a model, the arrangement of the dimensions used in modules can impact the speed of calculations. In the lesson, learn how the sequence of dimensions affects the calculations performed in the model and how simple it is to consistently align the dimension order for all modules in the model. Audience: Model…
-
Using the Compare Functionality
Summary: The Compare feature lets you compare data values in a module. You can choose to compare the data against a different version, a list, or a time period. This lesson reviews the functionality and options for the Compare platform feature. Audience: Model Builders Lesson Duration: 5 minutes Lesson Location: This…
-
Subsidiary Views
Summary: A subsidiary view is a line item that contains different dimensions from the module in which it resides. Subsidiary views do not have a large impact on performance, but they can be hard to identify and difficult to locate when working in a model. This lesson reviews the recommended best practices for when and when…
-
Model Options for Calculation Efficiency and Performance
Summary: One of the greatest sources of impact on model performance are the calculations running in a model. There is no simple solution for calculation efficiency. Every situation, model, and formula is different. This lesson provides some general guidelines and principles that can be used to review formulas and decide if…
-
Dependent Calculations
Summary: There are multiple ways to structure calculations that all provide the same result. Dependent calculations reference the output of other calculations within the formulas. Using dependent calculations can impact model efficiency and performance. This lesson will review best practices for using dependent…
-
Thinking Through Your Formulas
Summary: This lesson reviews key questions and considerations that you should use as you plan out the formulas used for calculations and data transformation in a model. It also reviews best practices for using SUM and LOOKUP functions to help align source and target dimensions. Creating efficient formulas will improve…
-
How to Adjust or Override a Previously Calculated Value
Summary: This lesson explains how to create functionality that allows end users to manually input a new value to override an initial value and include the adjusted value in other calculations. Audience: Model Builders Lesson Duration: 3 minutes Lesson Location: This micro-lesson is also available in the Level 2 Model…
-
Front to Back Model Design
Summary: This lesson reviews best practices for designing a model - beginning with the end users' experience and how each role will interact with the model to complete the business process. This lesson also provides a practice scenario to try the model design process steps for yourself. Audience: Model Builders Lesson…