Data Modeling

When procedures triggered from screens fail you 😯
We are looking at all cases where a procedure executed from a screen can fail and stop. We have found what I relate below. ⚠️ Could you, please, point to additional cases? This way they are registered for future consultation by other members of the Community. ⚠️ When a procedure is launched from a screen, it can be with a…
Delete/Update Entity members
Hi BOARD Team, If we want to change the Max Item for an entity, the best practice is to do it in test environment and then use the Transporter to update the production environment. Question 1: If I need to delete members from the entity, can I do it safely in the production environment? Question 2: I want to reload entity…
Creating Versions for Info-Cube
Hi Board Team, I have watched BOARD Academy video about optimizing cube performance by creating different version. Is there any disadvantage / issue for creating versions? Can I create version directly in the production environment? Thanks
mirrored Leaf in unbalanced Hierarchie
The unbalanced hierarchy is a strong function. Unfortunately, it is only possible to aggregate using a single tree. Hierarchy nodes Description Root Node A node that is not assigned under any node and has no parent node (predecessor). Node A node that has successors, which means all nodes except for leaves. Leaf A node…
Data Model Snapshot - Environment Type Incorrect
I noticed when creating snapshots of my data models in the production site that the Environment is listed as "Dev" and not "Platform." The instance is correct for the production site and I confirmed on our admin portal that the Instance Type is Platform, however it's showing as Dev in the Data model snapshot. I can get…
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!
Raise the limit of Custom Time Entities on Time Range
Main Idea: Today, the number of Custom Time Entities is limited to 4. My idea would be to raise this limit number to at least 10. It would be great to have no limit, if possible. The last project I worked on lasted 40 days. If I had a free custom time entity, I could have saved around 3 to 4 days of work, which is a…
Entity 'Copy' feature should be made available, apart from the 'Replicate' feature.
Hi, I hope this IDEA finds you all good and helpful. This IDEA concerns a simple feature that is currently not available in the Board application and making this available can help solving many issues related to the Incorrect reports and data. Cause of IDEA: Many users use the 'Replicate' feature, thinking that they are…
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…
B14 - Less clicks, less blocking popups
Board 14 requires in some parts too many clicks which slows down the process working with e.g. the data model. An example - Adding an entity: B12: +Entity (1st click), Save Changes (2nd click), Next Entity … B14: + (1st click), Entity (2nd click), Create (3rd click), Wait approx. 3,5s for Popup to disappear, Close (4th…
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…
Multiple Down/Sub Total Rows in a single Data View
Dear Community, I would like to propose the addition of multiple sub/down total rows in a single data view. It would allow for not only a sum row at the bottom of each data set but also an Average row or other analytical calculations that summarize the data. This would give users a more detailed and versatile summary of…
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…
Capsule Procedure vs Datamodel Procedure
1. Abstract While developers are facing procedure creation, they need to understand when it is appropriate to use data model procedures vs Capsule procedures. 2. Context As developers, it is our responsibility to always keep the long-term maintainability of our solutions in mind. Procedures must be developed in a…
ALM - Merge Branch
At present, developers can only develop together on one MasterDB. This can lead to problems in large projects with many developers. Example: Developer 1 starts a procedure to calculate values in a cube. Developer 2 has to empty an entity that is contained in the above-mentioned cube. For example, because the MaxItem number…
Impact Analysis - Data Lifecycle
If incorrect or no data is displayed in an existing report, a developer must find the cause. This can be very time-consuming, especially if the database is very large and or was developed by other colleagues. The aim of this feature is to support the developer in exactly this search. A first starting point is the impact…
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…
Public list of known bugs available for customers & partners
It would be useful have available in the manual or somewhere in support site a list of known bugs / problems / unwanted behaviours and a plan for fixing. This will save a lot of time and money! Sometime happen that some function is not working properly. I've recently spent more than 1 day + half day of ext consultant to…
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…
Procedure Execution Flow - Action Status
Problem to solve When modelling, business logics are encapsulated in separate procedures. This has the advantage that they can be called from anywhere without creating redundant logic. With the "call procedure" step, a procedure can call one or more child procedures. There is currently no simple way to return a functional…

Data Modeling

Discussion List