-
Selection of values in a block based on another block
I would like to offer the following functionality and wonder if achieving it in Board is possible. As per below table, for each line item the user would categorise the line item with an object Type in block b. This is a block of type entity where user selects the object type from the dropdown. Based on the selection made…
-
Update pre-existing time entities
I have two questions - Can we update the description of pre-existing time entities using data reader?For example - In BOARD ,day entity has code = 20240919 and description = 19/09/2024.I want to replace description with "Thursday". My Fiscal Year starts from July.I want my weeks counting to start from July instead of…
-
Unable to load unbalanced hierarchy throught datareader
Hi, I have followed the steps mentioned in attached article on how to create unbalanced hierarchy. I have successfully loaded the entity members. Now as I try to define their relationship I am unable to do so. I want to assign AC2 as parent of AC3. Kindly help!
-
Setting time range and time entity relationships
Once a year, I plan a task to extend the time range by one year. I tried extending it by a year, which resulted in unexpected changes to the time entity relationships. In the example below, the number of child entities Month for FY=2023 should remain 12, but has become 3. Before the time change After the time change I have…
-
How to define and manage the time range
1. Abstract In Board, the definition of the time range becomes very important because it guides the data that will be loaded and made visible to the end user. When setting the time interval, there are some considerations to bear in mind to avoid running into unpleasant situations during the development phase, where the…
-
Analytical Functions
Hi Board Team, I found the following calculation in one of the procedure. I understand From and To is used define the time range. But I cannot understand what Yearly Rolling Periods and Last Selected Period pointing to. If we use today 9th July 2024 as an example, which month range will the following pointing to? Thanks
-
Transporter Tool
Can we use the transporter tool for transferring the metadata between data models in same server?
-
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…
-
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
-
Historicisation of relationships
1. Abstract In Board, hierarchies are without time reference as standard. This simplifies data modeling in many cases. In some cases, however, it is necessary to map relationships between different nodes in a time-dependent manner and thus to historicize the values. There are different methods for this, which are to be…
-
Naming Convention
1. Abstract The following document is intended to suggest and give concrete examples of the nomenclature to be used during the development of the back end and front end of a Board solution. The aim is to have a consistent and organized nomenclature that led to a maintainable solution that can be easily consulted in the…
-
Is it possible to separate the values of the cube when the same screen is opened in multiple tabs?
Hello. - Hello. As the title says, when the same screen is opened in multiple tabs, Is it possible to separate the cube of selected values used in that screen? Example: "DisplayEntity" member =A,B,C,...,Z,not selected "parent1" member =A~G,H~N,O~U,V~Z,not selected "parent2" member =1,2,not selected Relationship: child…
-
Numeric cubes only in double
Hi, A long time ago I received the following advice: only use "double" cubes. Loading values between int and double, or single and double types could be buggy and fail unexpectedly. Is this still advice we should be following? I have been creating all my numeric cubes as double types, even the matrix cubes that are always…
-
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 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…