Data Modeling

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 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…
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…
Default Database Security Profile while creating a new DB - ADMIN
Dear Team, Currently when we create a Database, it is setup without any Security Profile. Could we please look to add the step of adding a default Database Security Profile - ADMIN at the time of creating a new Data model. We could have this done behind the scenes as soon as the developer finishes setting up the time range…
Dynamically manage calendar settings
1. Abstract In many cases, we will need certain mappings in our Calendar to define specific time frames for reporting and planning purposes. Some of those may be custom time dimensions and others might be created by mapping the standard calendar to specific periods. All those mappings have to be kept up-to-date. That can…
Pagination for API-Queries
API-Queries are a great way to expose Data to other Board-Systems or third-party-applications. Big Data-Sets could end in Time-Out. It would be helpfull to cut big datasets in smaller pieces with pagination. Please have a look on Pagination on REST API call Procedure step.
Sending data between data models.
Hi Board, We have two different data models and we need to sedn data from the one data model to the other and vice versa. Currently what we have tried is the following: Extract the data from data model A, call a procedure in data model B that would import the extract through Azure using a data reader and paste the data…
Sparsity
1. Abstract During the creation of a new cube, the question is usually about whether dimensions should be dense or sparse. A cube can store a value for any combination of its dimension’s members: for example, a three-dimensional Cube (e.g. month, product and customer), has a cell for any triplet. If every customer…
How to compare 2 different cubes to show an alert?
Hi Community! I am working on figuring out a way to compare two different data entry cubes to show alerts. The goal is to have one DE cube to match the sum of by Month DE cube values, and if the sums don't match the alert or notification will appear. Are there any ideas on how would be best to approach this?
How to do multi level allocation
1. Abstract A Multi-Level cost allocation is an important process of any business, it plays a huge role in the decision-making process, and that’s why we must design it in the best possible way. The Multi-Level cost allocation consists of applying a classic allocation but with the possibility that an element can be at the…
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 structure cubes with slow moving hierarchy
1. Abstract A common challenge in a Board Application is to fulfill the request of tracking changes in hierarchies, which by definition are the current snapshot of a relationship. This article describes how to keep track of the historical situation using a cube and dedicated entities. 2. Context Since a hierarchy in Board…
Missing child in Relationships
Hi, I'm trying to create a dashboard on ESG Net Zero Emission. I've picked only a particular worksheet (1a_RM_&_pack_calc_1.csv) and created entities and built relationships for them, but after running the Data Reader, I'm getting an error on Missing Child in relationships. Thanks & Regards, Kranthikumar Goli.
Integrated technical documentation functions
1. What is your idea? The Idea is, to have the possibility to directly document the application within Board. For example: Entity Comment possibility for each Entity technical name Cubes Naming Convention field / technical name possibility to comment (maybe overall and in addition on Cube Version level) Value explanation…
Dataflow common mistakes and best practices
1. Abstract The dataflow is the main action to perform calculations between cubes, it is used in all the processes of the application, therefore it is very important to know how to set up a dataflow in the best possible way, to obtain the correct results with the best performances. 2. Context In this article, we will first…
Best Practices in Writing Procedures
1. Abstract Most probably every Board application will have procedures to cover interactivity by the user (e.g., navigation), perform calculations (e.g., processing plan data) or run other backend processes like creating a backup. To provide the best maintainability, quality, and robustness, some guidelines should be…
Impact Analysis update of information
Good morning, Our team would like to know if there's a method to update the impact analysis information. We have verified some cases where a name of a procedure or a screen is changed manually but this is not reflected in the impact analysis, which still shows the previous name. We believe having seen this for other…

Data Modeling

Discussion List