--- title: "Board Best practices" slug: "board-best-practices" description: "Explore Board Best Practices: guidelines for Data Model complexity, Capsule design, Cube optimization, ALM strategy, and performance tuning for scalability and maintainability." tags: ["Board Best Practices", "Multiple Data Models"] updated: 2026-05-21T07:44:43Z published: 2026-05-21T07:40:27Z canonical: "help.board.com/board-best-practices" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.board.com/llms.txt > Use this file to discover all available pages before exploring further. # Board Best Practices Are you looking for tips on the best practices for using Board? Did you know that we have a whole section dedicated to best practices on our Community website? Below is a list of our **Board Best practice articles** written by our subject matter experts and the Center of Excellence department. ![](https://us.v-cdn.net/6037492/uploads/H82AW4KAPUL8/1088x612-post-header-best-practices-28002-29-281-29.jpg) ## Best practices table of contents **Time Range** - [Custom Time Entities - Generic Month example](https://community.board.com/discussion/16665/custom-time-entities-generic-month-example) **Entities and Relationships** - [Managing high-volume Entities](https://community.board.com/discussion/16422/managing-high-volume-entities) - [Auto Max Item NR](https://community.board.com/discussion/16439/auto-max-item-number) - [Set up Relationships](https://community.board.com/discussion/16322/relationship) - [Data Transformation](https://community.board.com/discussion/16277/data-transformation) - [Relationships - scanning for errors](https://community.board.com/discussion/16323/relationship-scanning-for-errors) - [Entity Definition - Concatenation or not](https://community.board.com/discussion/16602/entity-definition-concatenation-or-not) - [Data Load Guidelines](https://community.board.com/discussion/16253/data-load-guidelines) - [Historicization of Relationships](https://community.board.com/discussion/17990/historicisation-of-relationships/p1?new=1) **Cubes** - [Cube Definition Insight](https://community.board.com/discussion/16408/cube-definition-insights) - [Sparsity](https://community.board.com/discussion/16440/sparsity) - [Temporary Cube vs staging Cube](https://community.board.com/discussion/16251/temporary-cube-vs-staging-cubes) - [Multiple Cubes or measure Entity](https://community.board.com/discussion/16252/multiple-cubes-or-measure-entity) - [Cube Maintenance Strategy](https://community.board.com/discussion/20177/cube-maintenance-strategy) **Procedures** - [Dataflow common mistakes and best practices](https://community.board.com/discussion/16516/dataflow-common-mistakes-and-best-practices) - [Best practice in writing Procedures](https://community.board.com/discussion/16734/best-practices-in-writing-procedures) - [Capsule Procedure vs DB Procedure](https://community.board.com/discussion/16463/capsule-procedure-vs-datamodel-procedure) - [Clear Cube insight](https://community.board.com/discussion/16254/clear-cube-insight) - [Initialization process, Versioning and Simulation](https://community.board.com/discussion/16620/initialization-process-versioning-and-simulation) - [Data Export functionalities](https://community.board.com/discussion/16324/data-export-functionalities) - [Moving data](https://community.board.com/discussion/16351/moving-data) - [Rule Consolidation](https://community.board.com/discussion/16370/rule-consolidation) - [Selection option in Procedure](https://community.board.com/discussion/16258/selection-options-in-procedures) - [Allocation with Board](https://community.board.com/discussion/16923/allocation-with-board) - [Period-by-period recursion - Tips and use cases](https://community.board.com/discussion/17446/how-to-use-period-by-period-recursion?utm_source=community-search&utm_medium=organic-search&utm_term=period+recursion) **Modeling** - [Offset Rules](https://community.board.com/discussion/16398/offset-rules) - [Naming convention](https://community.board.com/discussion/16369/naming-convention) - [Use of Nexel](https://community.board.com/discussion/16423/use-of-nexel) - [Normalize in High Concurrency](https://community.board.com/discussion/17182/normalization-in-high-concurrency/p1?new=1) - [Dynamically manage calendar settings](https://community.board.com/discussion/17317/dinamically-manage-calendar-settings/p1?new=1) - [Dummy Entity elements for budgeting purposes](https://community.board.com/discussion/17378/dummy-entity-elements-for-budgeting-purposes/p1?new=1) - [Data Access Control](https://community.board.com/discussion/16564/data-access-control-architecture) - [Security Recommendation](https://community.board.com/discussion/19743/security-recommendation) - [Migrating away from TILDE](https://community.board.com/discussion/19789/migrating-away-from-tilde-datamodel) - [High Concurrency Planning](https://community.board.com/discussion/20052/high-concurrency-planning) **Screen and Reporting** - [On-the-fly calculation Pros and Cons](https://community.board.com/discussion/16256/on-the-fly-calculations-pros-and-cons) - [Navigation - Tips & Common Mistakes](https://community.board.com/discussion/16452/navigation-tips-common-mistakes) - [Application Navigation Design](https://community.board.com/discussion/16451/application-navigation-design) - [Reporting Layer: Optimize a report](https://community.board.com/discussion/16650/reporting-layer-optimize-a-report) - [Use of Number Scaling](https://community.board.com/discussion/16384/use-of-number-scaling) - [Drill Actions](https://community.board.com/discussion/16565/drill-actions) - [Data entry saving methods](https://community.board.com/discussion/16350/data-entry-saving-methods) - [Comparison between different versions/scenarios in the same repor](https://community.board.com/discussion/16528/comparison-between-different-versions-or-scenarios-in-the-same-report)t - [Drill Anywhere Options: "Drill To" vs "Go To"](https://community.board.com/discussion/17106/drill-anywhere-options-drill-to-vs-go-to) - [Data entry input validation rules](https://community.board.com/discussion/17606/data-entry-input-validation-rules) - [The Use of Tab Container](https://community.board.com/discussion/16399/the-use-of-tab-container) **System Admin** - [Synchronize multiple data models](https://community.board.com/discussion/16698/synchronize-multiple-data-model) - [Broadcasting & Notification Tool](https://community.board.com/discussion/16464/broadcasting-notification-tool) - [Data Access Control](https://community.board.com/discussion/16564/data-access-control-architecture) - [The backup mentality](https://community.board.com/discussion/16529/the-backup-mentality) - [Avoid Using Time/Date Substitution Formula in backup custom path](https://community.board.com/discussion/19704/avoid-using-date-time-substitution-formulas-in-backup-custom-paths) **Integration** - [Triggering Procedures with REST API Calls from within Board](https://community.board.com/discussion/17253/triggering-procedures-with-rest-api-calls-from-within-board/p1?new=1) **Solution** - [Migrate from BFC to GCR](https://community.board.com/discussion/17267/migrate-from-bfc-to-gcr) - [Period Types in GCR](https://community.board.com/discussion/17520/period-types-in-gcr/p1?new=1) - [Equity Method Accounting BFC/GCR](https://community.board.com/discussion/17521/equity-method-accounting-bfc-gcr/p1?new=1) - [iXBRL with Seahorse](https://community.board.com/discussion/17550/ixbrl-with-seahorse/p1?new=1) For step-by-step guidance on specific use cases, take a look at the table of contents of our [How-to Guides](https://community.board.com/categories/how-to-guides).