--- title: "Board How-To guides" slug: "board-how-to-guides" description: "Access Board How-To Guides: practical tutorials covering setup, modeling, Capsules, translation, add-ins, and advanced feature workflows." tags: ["Board How-To", "System Administration", "Time Range", "Entities", "Relationship", "Cube", "Procedure", "Data Management", "GCR"] updated: 2026-05-21T07:44:56Z published: 2026-05-21T07:33:01Z canonical: "help.board.com/board-how-to-guides" --- > ## 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 How-To Guides Are you looking for how-to guides for using Board? Did you know that we have a whole section dedicated to how-to guides on our Community website? Below is a list of our **Board How-To articles** that provide step-by-step guidance to support specific use cases, written by our subject matter experts and the Center of Excellence department. Check out our table of contents for [Best Practices](https://community.board.com/discussion/16921/table-of-contents-best-practices) where you learn the best ways to use the platform for most situations. ![](https://community.board.com/home/leaving?allowTrusted=1&target=https%3A%2F%2Fus.v-cdn.net%2F6037492%2Fuploads%2FLSRVDQ66WQ6C%2F1088x612-article-cover-how-to-guide-28002-29.png) ## How-to guides table of contents **Time Range** - [How to define & manage the Time Range](https://community.board.com/discussion/16407/how-to-define-and-manage-the-time-range) - [How to set up a 4/4/5 calendar](https://community.board.com/discussion/16845/how-to-set-up-a-4-4-5-calendar) - [How to overcome the challenges of a Weekly Fiscal Calendar](https://community.board.com/discussion/19988/how-to-overcome-the-challenges-of-a-weekly-fiscal-calendar) **Entities and Relationships** - [How to change the Entity order](https://community.board.com/discussion/16268/how-to-change-the-entity-order) - [How to remove obsolete entity members](https://community.board.com/discussion/16273/how-to-remove-obsolete-entity-members) - [How to Edit Max item Number](https://community.board.com/discussion/16274/how-to-edit-the-max-item-number) - [How to use Unbalance Hierarchy](https://community.board.com/discussion/16748/how-to-use-unbalanced-hierarchy) - [How to make multiple relationships coexist in the same hierarchy](https://community.board.com/discussion/17383/how-to-make-multiple-relationships-coexist-in-the-same-hierarchy) - [How to version a hierarchy](https://community.board.com/discussion/19872/how-to-version-a-hierarchy) **Cubes** - [How to structure cubes with slow-moving hierarchy](https://community.board.com/discussion/16830/how-to-structure-cubes-with-slow-moving-hierarchy) **Procedures** - [How to merge actual figures in planning cubes](https://community.board.com/discussion/16684/how-to-merge-actual-in-planning-cubes) - [How to log procedures' execution with timestamps](https://community.board.com/discussion/16603/how-to-log-procedures-execution-with-timestamps) - [How to allocate with a dynamic driver](https://community.board.com/discussion/16977/how-to-allocate-with-a-dynamic-driver) - [How to do multi-level allocation](https://community.board.com/discussion/17051/how-to-do-multi-level-allocation) - [How to use period by period recursion](https://community.board.com/discussion/17446/how-to-use-period-by-period-recursion) - [How to do top-down allocation of an integer value](https://community.board.com/discussion/17774/how-to-do-top-down-allocation-of-an-integer-value/p1?new=1) - [How to use Nexel to select custom time periods](https://community.board.com/discussion/17840/how-to-use-nexel-to-select-custom-time-periods) - [How to loop procedures](https://community.board.com/discussion/18090/how-to-loop-procedures/p1?new=1) - [How to flag periods between two dates](https://community.board.com/discussion/18685/how-to-flag-periods-between-two-dates/p1?new=1) **Modeling** - [How to create a Workflow process](https://community.board.com/discussion/16517/how-to-create-a-workflow-process) - [How to manage BoM Explosion](https://community.board.com/discussion/16856/how-to-manage-bom-explosion) - [How to manage mapping DE](https://community.board.com/discussion/16889/how-to-manage-mapping-data-entry) - [How to allocate production by CM1](https://community.board.com/discussion/17366/how-to-allocate-production-by-cm1/p1?new=1) - [How to manage the currency conversion](https://community.board.com/discussion/17667/how-to-manage-the-currency-conversion) - [How to manage the leap year in comparative analysis](https://community.board.com/discussion/17933/how-to-manage-the-leap-year-in-comparative-analysis/p1?new=1) - [Dynamic Replenishment Model: Key Calculations & Formulas](https://community.board.com/discussion/18064/dynamic-replenishment-model-key-calculations-formulas/p1?new=1) - [How to create a Kanban board](https://community.board.com/discussion/18426/how-to-create-a-kanban-board/p1?new=1) - [How to use validation rule to avoid special characters in text Cubes](https://community.board.com/discussion/18983/how-to-use-validation-rule-to-avoid-special-characters-in-text-cubes) - [How to ensure correct rule behavior when using entity sorting *Build Along with Board](https://community.board.com/discussion/19802/how-to-ensure-correct-rule-behavior-when-using-entity-sorting) - [How to map Entities using text Cubes](https://community.board.com/discussion/19849/how-to-map-entities-using-text-cubes) **Screen and Reporting** - [How to design screens & dashboarding](https://community.board.com/discussion/16814/how-to-design-screens-dashboarding) - [How to format a report and create entity members](https://community.board.com/discussion/16383/how-to-format-a-report-and-create-entity-members) - [How to hide/ignore columns of an Excel data source when using the Smart Import Object](https://community.board.com/discussion/16419/how-to-hide-ignore-columns-of-an-excel-data-source-when-using-the-smart-import-object) - [How to show the value of different dimensioned cube only in total line](https://community.board.com/discussion/16402/how-to-show-the-value-of-different-dimensioned-cube-only-in-total-line) - [How to group selectors using tabs with vertical display](https://community.board.com/discussion/17856/how-to-group-selectors-using-tabs-with-vertical-display) - [How to create bar chart in Data View](https://community.board.com/discussion/19404/how-to-create-bar-chart-in-data-view) - [How to address common challenges in developing Board presentations](https://community.board.com/discussion/19930/how-to-address-common-challenges-in-developing-board-presentations) - [How to Transform Sub Hub User Export Data into a Governance Dashboard](https://community.board.com/discussion/19964/how-to-transform-sub-hub-user-export-into-a-governance-dashboard) **System Admin** - [How to manage security with Metadata](https://community.board.com/discussion/16453/how-to-manage-security-with-metadata) - [How to migrate to Subscription Hub](https://community.board.com/discussion/18255/how-to-migrate-to-subscription-hub/p1?new=1) **Integration** - [How to send notifications - Integration with Ms Teams](https://community.board.com/discussion/16636/how-to-send-notifications-integration-with-ms-teams) - [How to set parametric WHERE clause for SAP Connector in a BOARD Procedure](https://community.board.com/discussion/16869/how-to-set-parametric-where-clause-for-sap/p1?new=1) - [How to integrate with Dynamics 365 OData APIs](https://community.board.com/discussion/16756/how-to-integration-with-dynamics-365-odata-apis) - [How to trigger SQL server actions](https://community.board.com/discussion/17707/how-to-trigger-sql-server-actions/p1?new=1) - [How to replace REST Connector with REST API Call](https://community.board.com/discussion/17814/how-to-replace-rest-connector-with-rest-api-call) - [How to set up SAP Connector Architecture](https://community.board.com/discussion/18028/how-to-setup-sap-connector-architecture/p1?new=1) - [How to set up a Rest API connection](https://community.board.com/discussion/18138/how-to-set-up-a-rest-api-connection/p1?new=1) - [How to use advanced SQL statements to Bulk Insert in SQL table](https://community.board.com/discussion/18785/how-to-use-advanced-sql-statements-to-bulk-insert-in-sql-table) * Build Along with Board - [How to display images stored in the azure storage](https://community.board.com/discussion/19688/how-to-display-images-stored-in-the-azure-storage) - [How to display images stored in Google cloud storage](https://community.board.com/discussion/19890/how-to-display-images-stored-in-the-google-cloud-storage) - [Integrating Board with Google BigQuery](https://community.board.com/discussion/19949/integrating-board-with-google-bigquery) - [Integrating Board with Databricks](https://community.board.com/discussion/20115/integrating-board-with-databricks) **Solutions** - [How to update GCR/FCR version](https://community.board.com/discussion/17089/how-to-update-gcr-version/p1?new=1) - [How to calculate branch contributive view in GCR/FCR](https://community.board.com/discussion/17526/how-to-calculate-branch-contributive-view-in-gcr/p1?new=1) - [How to configure FX simulation in GCR/FCR](https://community.board.com/discussion/17525/how-to-configure-fx-simulation-in-gcr) - [How to load IC details in BFC](https://community.board.com/discussion/17551/how-to-load-ic-details-in-bfc/p1?new=1) - [How to update GCR version (1.0.0 vs 1.0.2)](https://community.board.com/discussion/17744/how-to-update-gcr-version-1-0-0-vs-1-0-2) - [How to update GCR version (1.0.1 vs 1.0.2)](https://community.board.com/discussion/17743/how-to-update-gcr-version-1-0-1-vs-1-0-2) - [How to change the time range in GCR](https://community.board.com/discussion/17913/how-to-change-the-time-range-in-gcr) - [How to update GCR version (1.0.2 vs 1.0.3)](https://community.board.com/discussion/18199/how-to-update-gcr-version-1-0-2-vs-1-0-3/p1?new=1) - [How to update GCR version (1.0.3 vs 1.1)](https://community.board.com/discussion/18625/how-to-update-gcr-version-1-0-3-vs-1-1/p1?new=1)