Data Modeling

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…
Dataflow Algorithm Visibility and Optimization (HBMP / Tuples ...)
Enable users to visually inspect dataflow algorithms in the procedure without executing the entire process and reviewing database logs. Additionally, provide automated suggestions for optimizing dataflow performance based on usage patterns and efficiency opportunities. This feature enhances performance management within…
Enhancing Data Entry: Refer-To & Layout Selections
We suggest adding the ability to modify data entry cubes in a data view when refer-to and/or layout selections are present. This would allow for: Simplifying the design of data entry templates Reducing the size of the data model as it would require fewer cubes. Implementing this feature would not only enhance user…
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…
Disable the sort action on the DB Log
Hi Team, We faced this issue multiple times with many partners, where the database logs are being sorted (either by mistake or to check something). Group by logs could be useful, but the database logs sorting always adds to the confusion. thanks, Aniket
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…
Add sorting information to Entity-Export
We currently get information about the members of an entity to be extracted as Code/Member for standard entities and Code/Member/Parent for UBHs. Unfortunately, although there is an option to sort entity members by "Custom" (and we can import the sorting order for those entities), the sorting order information is missing…
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 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…
How to use Unbalanced Hierarchy
1. Abstract A common requirement when structuring hierarchies in Board is to create an unbalanced hierarchy, Board facilitates this with a dedicated feature “Unbalanced Hierarchies”. 2. Context Unbalanced hierarchies can be a very useful addition to a Board solution; however, how to define and maintain them requires some…
Partitioned cubes and sparsity
When performance problems occur, one bottleneck is backing up the data on the hard drive. We can counter this by setting the saving policy. Depending on the selected setting, it is a trade-off between performance and security. With my suggestion I would like to defuse this tension. With the SQL-Server from Microsoft it is…
metadata-driven modeling with BAML (Board Application Markup Language)
This feature is inspired by BIML (Business Intelligence Markup Language). To develop a board-application you don’t need coding skills. That is really great for beginners! To develop a board-application is mostly to create or alter meta-data. For example create a new entity. Give them a name, group, id length, desc length…
Audit/Record changes to procedures / lines
As an on-going maintenance task, we frequently have to modify procedures (add more lines, modify existing, disable lines, etc.) It would be nice if (upon saving) the username/timestamp and action is recorded against each line (e.g. added, disabled, modified, etc). This can be used, in part as a version control mechanism.…
Data Model object comments
For Data Model objects it would be informative to have to possibility to add comments and notes. For example a Procedure, under “Options” or a new tab, give the developer the possibility to write comments i.e. the purpose of the procedure, when it was last updated, who created/updated it. It could either be one big…
Resize Columns in ETL Tab of Data Readers
Maybe we are unique in having a field that is very long, but having the ability to manually change the width of columns in the ETL would be fantastic. We have different combinations of materials that can go into our goods, all depending on what has been ordered. In order to make this happen and price things appropriately,…
Extracting list of cubes via Entity analysis
Currently the list of cubes for a particular entity can be extracted through Impact Analysis which only provides the cube name and not other details. If the user is able to extract the list of cubes via Entity Analysis (by clicking on Go to Cubes), it will provide details such as Group name, Data Type, no. of Versions and…
How to make multiple relationships coexist in the same hierarchy
1. Abstract Establishing and managing relationships effectively is crucial for the optimal performance of a Board implementation. In numerous instances, it becomes necessary to accommodate multiple relationships within the same hierarchy. Therefore, it is vital to make informed decisions when constructing the…
Dummy entity elements for budgeting purposes
1. Abstract In planning processes, sometimes it is necessary to manage new occurrences that don’t exist in real life yet, which means creating provisional elements in the master data that will serve only for planning purposes. 2. Context Creating provisional elements in master data for planning purposes means creating new…

Data Modeling

Discussion List