-
How to use validation rule to avoid special characters in text cubes
1. Abstract Text cubes in Board applications serve as flexible data entry points, allowing users to input free text such as comments, narratives, or descriptions. While these cubes offer a simple interface for capturing data, they also come with a set of challenges due to the variety of text input formats that users may…
-
How to create a Kanban board
1. Abstract It's quite typical to incorporate a workflow for monitoring and managing various activities into Board applications. In certain situations, leveraging a Kanban board can greatly facilitate simplifying the visualization, monitoring, and control of these tasks. In Board, the card object fits perfectly for this…
-
Dynamic Replenishment Model: Key Calculations & Formulas
1. Abstract Retail replenishment is the process of counting the inventory you have left in stock and reordering the right amount of stock at the right time. In other words, it's the process of ensuring that you always have sufficient inventory in store to meet customer demand. 2. Content As part of the standard Board…
-
How to manage the leap year in comparative analysis
1. Abstract In an application life cycle it is not unusual to come across leap year management, moreover when comparative analysis are put in place. Accurate handling of leap years ensures data consistency across different timeframes, preventing discrepancies when comparing results from different years or performing…
-
How to manage the currency conversion
1. Abstract Nowadays, most companies work on a global level and accordingly also have the need to be able to display and edit their KPIs in different currencies while keeping the ability of a consolidated view. In this article, we will first show how to implement a currency conversion where different local currencies and…
-
How to allocate production by CM1
1. Abstract This technical article describes a way of dealing with row-by-row calculation in Board without using Nexel. Nexel can be used for small examples but does not have a good performance in mass calculations. Keep in mind that not all row-by-row calculations can be transformed into “dataflow-only” calculations. Even…
-
How to manage mapping Data Entry
1. Abstract In many cases, mappings are used to control processes. Mostly, these are mappings between entities that cannot be implemented in the standard relationships (hierarchies) for various reasons (e.g. they are not n:1 relationships, or the hierarchical trees would become too large to be useful from a performance…
-
How to manage BoM explosion
1. Abstract For the production of an item, different materials/ingredients are used. For the production of these materials/ingredients, other materials are required. In the BoM Explosion, all materials of the different levels are written to one level. This article describes an approach within Board – based on a project…
-
How to create a workflow process
1. Abstract Many organizations would like to automate approval processes and workflows through Board software in order to create a reliable and standardized series of steps which guide users to ensure work is completed and approved the same way. In Board, a workflow intended as an approval process can be designed through a…