2.02-03 No Repeated expressions
If the expression is repeated in the formula (or other modules), put it on a separate line item. “Calculate once, reference many times”
Comments
-
Rule 2.02-03 No Repeated Expressions. If the expression is repeated in the formula (or other modules), put it on a separate line item. Calculate once, reference many times. It goes against PERFORMANCE, AUDITABLE, NECESSARY elements of PLANS if you wish to go against this rule
Here is how it was done in Pre Planual Era:
What is wrong with this method? Same thing is getting calculated four times at four different places. It surely adds work for the engine and it is absolutely unnecessary to get it done this way
Here is how it should be done in Planual Way:
Note: Condition Line item can be placed in a SYS Time module and shouldn’t be placed in the multidimensional module. The above snip is only for demonstration purposes
0
Title
- Preface
- PLANS
- Planual Conventions
- Zen of Anaplan
- Chapter 1 - Central Library
- Time
- Versions
- Users and Roles
- Contents
- Lists
- Subsets
- Line Item Subsets
- Emojis
- Chapter 2 - Engine
- Modules
- Formulas
- Line Items
- Saved Views
- Chapter 3 - UX Principles
- Hierarchy of Information
- Smart Grouping
- Reduce Visual Load
- Progressive Disclosure
- Use Consistency and Standards
- Provide Help and Guidance
- Use The Correct Data Type
- Give Users Visibility Into Status
- Match With Real World Scenarios
- Check In With End Uses Frequently
- Chapter 4 - UX Build
- Apps
- Dashboards
- Filters
- Chapter 5 - Integration
- Actions
- Processes
- Source Models
- Imports
- Exports
- Import Data Sources
- Data Hub
- Chapter 6 - Application Lifecycle Management
- Revision Tags
- Production Lists
- Architecture
- Deployed Mode
- Managing Changes During Development
- Chapter 7 - Extensions
- Excel
- PowerPoint